Oracle Database uses rowids internally for the construction of indexes.
red hat linux certification malaysia
A B-tree index, which is the most common type, contains an ordered list of keys divided into ranges. Each key is associated with a rowid that points to the associated row’s address for fast access.
red hat linux administration training courses malaysia
End users and application developers can also use rowids for several important functions:
- Rowids are the fastest means of accessing particular rows.
- Rowids provide the ability to see how a table is organized.
- Rowids are unique identifiers for rows in a given table.
red hat enterprise linux rhel training courses malaysia
You can also create tables with columns defined using the ROWID data type. For example, you can define an exception table with a column of data type ROWID to store the rowids of rows that violate integrity constraints. Columns defined using the ROWID data type behave like other table columns: values can be updated, and so on.
Leave a Reply