Name
SET TRANSACTION
Synopsis
SET TRANSACTION [NAME 'name
'] {READ ONLY | READ WRITE | ISOLATION LEVEL {SERIALIZABLE | READ COMMITTED} | USE ROLLBACK SEGMENTseg_name
}
Establishes the current transaction as read-only or read/write or specifies the rollback segment to be used by the transaction. If used, this statement must be the first in your transaction. A transaction is ended with a COMMIT or COMMIT WORK statement.
Keywords
- NAME
Specifies a name for this transaction. New with Oracle9i.
- READ ONLY
Specifies that the current transaction is read-only.
- READ WRITE
Specifies that the current transaction is read/write.
- ISOLATION_LEVEL
Specifies how database modifications are to be handled.
- SERIALIZABLE
If an attempt is made to update a row that has been updated and not yet committed by another session, the statement will fail; this situation is consistent with the serializable transaction isolation mode specified in the ANSI SQL-92 standard.
- READ COMMITTED
Oracle’s default behavior will be in effect, and if a row is locked by another uncommitted transaction, the statement will wait until the row locks are released.
- USE ROLLBACK SEGMENT
Assigns this transaction to the rollback segment specified by seg_name. This clause implies READ WRITE and cannot be specified with READ ONLY.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.