lock table syntax
Posted by:
dcliman
Date: February 12, 2007 07:09PM
The documentation for the LOCK TABLES command shows the following syntax:
LOCK TABLES
tbl_name [AS alias]
{READ [LOCAL] | [LOW_PRIORITY] WRITE}
[, tbl_name [AS alias]
{READ [LOCAL] | [LOW_PRIORITY] WRITE}] ...
UNLOCK TABLES
However, the examples all use the singular TABLE, e.g.
LOCK TABLE t WRITE, t AS t1 WRITE;
Are TABLES and TABLE synonymous? Must one use the singular if there's only one table in the list?
Subject
Views
Written By
Posted
lock table syntax
8437
February 12, 2007 07:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.