ORACLE: LOCK TABLE [EN]
top of page
CerebroSQL

Oracle:

LOCK TABLE

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;

bottom of page