LOCK TABLE

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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]