Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - UROWID
Versions: Oracle 11g, 10g and 9i
| Oracle - UROWID | |
|---|---|
| Syntax | UROWID [(p)] |
| Data | Logical row address for index-organized or foreign tables. Index-orginized tables store data in index leaves which can move. Foreign tables are external tables, for example in IBM DB2 database UROWID, an universal rowid, is based on primary key values |
| Parameters | p is the size of column in bytes, optional |
| Range | 1 ⇐ p ⇐ 4000 |
| Default | p is 4000 |
| Version Differences | Oracle 9i and later - UROWID data type is available |
| Standards | Oracle Extension |
Related Data Types in Oracle
| Data Types | ||
|---|---|---|
| Phisycal row address | ROWID | |
All Data Types