SQL Plus - What is ROWID

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 11 of 132

What is ROWID

Total Answers and Comments: 3

Last Update: June 18, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: Mangai Varma

Rowid is the physical address for each record in the database and it is a fixed-length binary data.

The format of the rowid is:

BBBBBBB.RRRR.FFFFF

where:

BBBBBBB is the block in the database file;

RRRR is the row in the block;

FFFFF is the database file.

Above answer was rated as good by the following members:
kiran_marla

July 09, 2005 23:02:25

Zimmy

RE: What is ROWID

ROWID is the psedo columns indicate the stored location of the data physically in the database.

Is this answer useful? Yes | No

August 31, 2006 02:49:30

Mangai Varma

RE: What is ROWID

Rowid is the physical address for each record in the database and it is a fixed-length binary data.

The format of the rowid is:

BBBBBBB.RRRR.FFFFF

where:

BBBBBBB is the block in the database file;

RRRR is the row in the block;

FFFFF is the database file.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

June 17, 2009 22:56:47

Ravi Gajula

Member Since: June 2009 Contribution: 1

RE: What is ROWID

The Address Field of the index is called ROW ID

Format: BBBBBBB.RRRR.FFFF
FFFF: Unique Number given by oracle engine to each Data file
BBBBBBB: each Data File is further divided in Data Blocks
RRRR: Data Blocks can store one or more Records

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank