Every row stored in the database has an address. Oracle Database uses a ROWID data type to store the address (rowid) of every row in the database.
sap fico financial accounting training courses malaysia
Rowids fall into the following categories:
- Physical rowids store the addresses of rows in heap-organized tables, table clusters, and table and index partitions.
sap erp pp production planning training courses malaysia - Logical rowids store the addresses of rows in index-organized tables.
- Foreign rowids are identifiers in foreign tables, such as DB2 tables accessed through a gateway. They are not standard Oracle Database rowids.
sap erp procurement material management training courses malaysia
A data type called the universal rowid, or urowid, supports all types of rowids.
Leave a Reply