| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: info about ROWID?
Dries,
Rowid is Oracle internal "record indentifer". It consists of the Oracle file #, the block # and the seq # within the block.
Rowid is the fastest way to hit the record because it literally contains the info. of where the row is located.
Some DOs and DONTs of using ROWID:
DOs :
DONTs :
Regards
Rajagopal Venkataramany
On Thu, 27 Jul 2000 08:08:50 -0800, ORACLE-L_at_fatcity.com wrote:
>
> Hello,
> Sorry if this is a very basic question, but i couldn't find good
information
> about it. In other databases, you normally define your ouwn ID, an
integer.
> Oracle 8i already has a ROWID. Using this ROWID should be faster if i
have
> to believe the docs.
> Should i use this ROWID in the tables or not? Any experiences?
> Which characters can be contained in this ROWID? Does it give problems if
i
> have to pass rowid's as parameters in servlets or cgiscripts? Is it
possible
> that it contains chars like ' " / ? \
>
>
> Thanks in advance for any help,
> Dries
>
> --
> Author: Dries Verachtert
> INET: dries_at_ulyssis.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Regards
Rajagopal Venkataramany
 |
 |