Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle LOCK to HiRDB

If “lockmode” is 'ROW SHARE' or 'SHARE UPDATE' or 'ROW EXCLUSIVE' , remove LOCK TABLE DML. Also if “lockmode” is 'SHARE' or 'EXCLUSIVE' , convert to below. And If “NOWAIT” is specified , replace to “NO WAIT”. If “@dblink” is specified , remove “@dblink” TOKEN.

Oracle:

LOCK TABLE [schema .]table_name[@dblink ], …
IN lockmode MODE [NOWAIT] ;

HiRDB:

LOCK TABLE  [schema .]table_name, …
 IN lockmode MODE [NO WAIT] ;

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.