Топ-100
 
CerebroSQL

LOCK TABLE

RDBMS Type: Oracle

unnamed (2).png

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;