Топ-100
 

LOCK TABLE

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

LOCK TABLE [ schema. ] { table | view }
[ partition_extension_clause
| @ dblink
] [, [ schema. ] { table | view }
[ partition_extension_clause
| @ dblink
]
]...
IN lockmode MODE
[ NOWAIT
| WAIT integer
] ;

Example

LOCK TABLE employees
IN EXCLUSIVE MODE
NOWAIT;

LOCK TABLE employees@remote
IN SHARE MODE;