Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

ROWID

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;