SET TRANSACTION
SET TRANSACTION
[READ ONLY]
[READ WRITE]
[ISOLATION LEVEL [SERIALIZABLE | READ COMMITTED] ]
[USE ROLLBACK SEGMENT seg_name
]
Establishes the current transaction as read only or read and write, or specifies the rollback segment to be used by the transaction.
Specifies that the current transaction is read only.
Specifies that the current transaction is read and write.
Specifies how Oracle should conform to the ANSI SQL92 Serializable Transaction specification for the transaction; you may specify:
Specifies that Oracle should conform to the ANSI SQL92 Serializable Transaction specification and roll back transactions that attempt to update rows being updated by another transaction.
Specifies that Oracle should continue to use its default processing and wait for the rows to be unlocked before continuing.
Assigns this transaction to a specified rollback segment. This clause implies READ WRITE, and cannot be specified with READ ONLY.