| 21. 26. 1. 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;
|
|