Trace: • Oracle Database - Row Locks (TX) • Oracle Database - SQL - ROW_NUMBER function • Oracle Database - Rowid Scans operation • Oracle Database - Runstats • Oracle Database - Sample SQL Clause for Table Scans/Access • Oracle Database - SAVEPOINT (of a transaction) • Oracle Database - Schema • Oracle Database - Schema Object • Oracle Database - Segment • Oracle Database - SELECT ... FOR UPDATE statement

You are here: Home » Database management system (DBMS) » Oracle Database » Oracle Database - SELECT ... FOR UPDATE statement

About
Articles Related
Documentation / Reference

Oracle Database - SELECT ... FOR UPDATE statement

About

The SELECT … FOR UPDATE statement is a special type of SELECT statement that does lock the row that it is reading.

It's the only exception where a reader can blocks a writer.

Articles Related

Documentation / Reference

The FOR UPDATE clause

database/oracle/select_for_update.txt · Last modified: 2010/12/20 11:30 by gerardnico