RE: info about ROWID?

It is a virtual column for Oracle's internal use, i.e. you cannot manipulate its values. You should use your own unique ID and only use rowid when referring to huge sets of data...speeds up record retrieval in some instances.
Regards,
Fiona McGonnell
Oracle Database Administrator
Salomon Smith Barney
Sydney, Australia.

-----Original Message-----
From: Dries Verachtert [mailto:dries_at_ulyssis.org] Sent: Friday, 28 July 2000 2:09
To: Multiple recipients of list ORACLE-L Subject: info about ROWID?

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).