LOCK TABLE 
[schema .] { table | view } 
[ { PARTITION ( partition ) | SUBPARTITION ( subpartition ) }
| @ dblink
] 
[, [schema .] { table | view } 
 [ { PARTITION ( partition ) | SUBPARTITION ( subpartition ) }
 | @ dblink
 ]
]...
IN lockmode MODE [NOWAIT];