Previous Topic

Next Topic

Inhoudsopgave

Book Index

Lock table <table_name> in {share | exclusive} mode

Lock table table_name in {share | exclusive} mode [wait nr_secs | nowait]

Explicitly locks table table_name with a shared table lock or an exclusive table lock. If the lock wait timeout is not specified, the default lock wait time is used.

Example

begin transaction

lock table T_Part in exclusive mode