RE: ok, no ROWID's as ID, what should i use instead? :-)

Yes, you may try SEQUENCES, command is CREATE SEQUENCE sequence_name HTH!
Aleem

 -----Original Message-----

From: 	Dries Verachtert [mailto:dries_at_ulyssis.org] 
Sent:	28 July 2000 14:06
To:	Multiple recipients of list ORACLE-L
Subject:	ok, no ROWID's as ID, what should i use instead? :-)

Hello,

Thanx for all the info about ROWID's. I still got the following questions:
* In many examples, people use NUMBER(38,0) for every ID. Is there a
certain speedup to use such large ID? For example my db has a table of winecolours with maybe 20 rows. Should i still use NUMBER(38,0) as ID because it is faster? NUMBER(38,0) seems to use 128 bits, does a number(?,?) always use that much bits maybe?

• ROWID is like an autonumber in access: it automagically increases when you insert a row in table. But ROWID's can't be used as a foreign key, so i can't use that. Is there something else in oracle that automatically increases and that can be used as index?

Thanx in advance, Received on Fri Jul 28 2000 - 06:40:26 CDT