LOCK TABLE

Non-relevant statement.

Notice that this statement is removed from the migration because it is a non-relevant syntax. It means that it is not required in Snowflake.

Description

In Oracle, the LOCK TABLE statement allows to explicitly acquire a shared or exclusive table lock on the specified table. The table lock lasts until the end of the current transaction. Review more information here.

Syntax

LOCK TABLE tableName IN { SHARE | EXCLUSIVE } MODE

Sample Source Patterns

Locking table

Notice that in this example the LOCK TABLE statement has been deleted. This is because Snowflake handles locking in a different method through transactions.

Oracle

LOCK TABLE table1 IN EXCLUSIVE MODE;

Snowflake

[Empty output]