Go4Oracle

Latest Articles

Saturday, 12 December 2009 | Sandeep

how to load text file Data into oracle database start sql plus make a TABLE according to your datago to command promptGo to folder that contain...
+ Full Story

Oracle Database Table

Friday, 06 November 2009 | Sandeep

A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table...
+ Full Story

Install Oacle 10G XE on linux ubuntu

Sunday, 08 March 2009 | Nandkumar

Install Oacle 10G XE on linux ubuntu
+ Full Story

Another Articles

Latest Blogs

Latest Entries

My Training on oracle
by dubey

My Oracle Training Details
by Monty

Dont get misguided by Some Training Institutes.
by amal

Latest Downloads

No Documents

ROWID OF A RECORD (PSUEDO COLUMN)

Written by Manish Sen

Rowid Is a Psuedo Column in oracle tables :

For each row in the database the row id psuedocolomn returns a row address .oracle 8 rowid value contain information nessasary to locate a row.

1. which data object number of the object.

2. which data bloch in the datafile.

3. which row in the data block ( first row is 0).

4. which datafile (first file is one) the file no is releted to table spaces.

usully a row id value uniquly identifies a row in the database , however row in the different table that r stored together in the same cluster can have the same rowid .

row id have saveral important uses :

1.they are the fastest way to access a single row.

2. they can show you how a table 's row are stored.

3they r unique identifiers for row in a table.

you should not use row id as table's primary key. If you delete and reinsert a row with the import/export utilities, its rowid may chang. if you delete a row, oracle may assign its rowid to a new row inserted later . although you can use the rowid psuedocolomn in the select and where clause of a query.