ROWID : ROWID « PL SQL Data Types « Oracle PL/SQL Tutorial






ROWID is a special datatype that enables you to store Oracle's internal key for database records.

Each row in an Oracle table has a unique internal key associated with it.

For example, you might use a cursor to retrieve a number of rows, including the ROWID for each row, and then use that ROWID in a DELETE statement to delete some of the rows.

Using the ROWID results in better performance because it tells Oracle exactly where to find the record.

The Syntax for the ROWID Datatype

variable_name ROWID;
employee_row_id ROWID;
21.26.ROWID
21.26.1.ROWID