Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

SET TRANSACTION

Synopsis

SET TRANSACTION [NAME 'name']
{READ ONLY  
| READ WRITE  
| ISOLATION LEVEL {SERIALIZABLE | READ COMMITTED} 
| USE ROLLBACK SEGMENT seg_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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page