Depending on the context, it could mean several things:
- Oracle Database locking: How row locks, table locks, transactions, deadlocks, and
LOCK TABLEwork. Oracle automatically locks rows duringINSERT,UPDATE,DELETE, andMERGEto maintain data consistency. Locks are typically released when youCOMMITorROLLBACK. - Locking a table manually: Using SQL such as:
-
LOCK TABLE employees IN EXCLUSIVE MODE; - This explicitly locks a table until the current transaction is committed or rolled back.
- Account lock: Locking or unlocking an Oracle database user account, for example:
-
ALTER USER scott ACCOUNT LOCK; ALTER USER scott ACCOUNT UNLOCK;- Vendor lock-in: Being dependent on Oracle products, making it difficult to migrate to another database platform.