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

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.