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
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.
Last updated