Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: to determine row position

Re: to determine row position

From: Rajagopal Venkataramany <rajagopalvr_at_excite.com>
Date: Thu, 14 Dec 2000 16:38:12 -0800 (PST)
Message-Id: <10710.124643@fatcity.com>


Indra,

  As u know the rowid consists of 3 components namely the datafile   number, the block number and a running seq no within the block.

  So by knowing the rowid, u come to know the exact physical address   of the record.

  Hope this answers your question...

Regards
Rajagopal Venkataramany

On Thu, 14 Dec 2000 16:06:15 -0800, ORACLE-L_at_fatcity.com wrote:

> Dear DBA,
>
> would I know the position of record in a table if
> I know the rowid, such as :
>
> ROWID INDICATI
> ------------------ --------
> 0006E87C.001B.0014 USA
>
> Please advise. Thank you.
>
> Indra
>
>

Regards
Rajagopal Venkataramany



Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/ Received on Thu Dec 14 2000 - 18:38:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US