December 2002
Intermediate to advanced
928 pages
85h 29m
English
LOCK TABLEtable_listINlock_modeMODE [NOWAIT];
Bypasses the implicit database row-level locks by explicitly locking one or more entire tables in the specified mode.
Comma-delimited list of tables.
Can be ROW SHARE, ROW EXCLUSIVE, SHARE UPDATE, SHARE, SHARE ROW EXCLUSIVE, or EXCLUSIVE.
Specifies that the RDBMS should not wait for a lock to be released. If there is a lock when NOWAIT is specified, the RDBMS raises the exception:
ORA-00054: resource busy and acquire with NOWAIT specified
The default RDBMS locking behavior is to wait indefinitely.