ORCIDGitHubLinkedIn
RSS Curriculum Vitae TR

ROWID

Turkish equivalent: Oracle satır adresiDomain: Oracle

An Oracle row address value that identifies the physical location of a row within a database object and can provide direct row access while the row remains at that location.

Version and Operational Boundary

ROWID is a physical row locator, not a durable business identifier. Row movement or object reorganization can invalidate assumptions about long-term identity.

  • Primary Key
  • Heap Table
  • Oracle Database
  • Physical Row Address

Source

  • https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ROWID-Pseudocolumn.html

Updated:

Related concepts

Oracle

Related technical publications

Publications whose title or summary directly references this concept.

Safe Row Updates in Oracle Without Reliable Unique Keys

Why a single-row update is unsafe in legacy Oracle tables whose uniqueness the database never enforced: separating business key from physical row identity, deterministic candidate selection, ROWID targeting, transaction boundaries, and ORM identity assumptions.