top of page
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