Message-Id: <10571.113187@fatcity.com> From: "Mcgonnel, Fiona" Date: Fri, 28 Jul 2000 10:32:32 +1000 Subject: 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@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@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@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).