Discussion Board

Read-only transaction The READ ONLY clause establishes the current transaction as a read-only transaction. This clause established transaction-level read consistency. Read-only transactions are useful for reports that run multiple queries against one or more tables while other users update these same tables. This clause is not supported for the user SYS. That is, queries by SYS will return changes made during the transaction even if SYS has set the transaction to be READ ONLY. Following statements are permitted in a read-only transaction: - Subqueries--that is, SELECT statements without the for_update_clause - LOCK TABLE - SET ROLE - ALTER SESSION - ALTER SYSTEM Prajakta Pandit 02-20-2017 11:57 PM

Write your comments

*

* Email must be in the form someone@domain.com

*

*