Re: ROWID is IDENTITY?

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 27 Sep 2001 20:49:26 GMT
Message-ID: <9p03cm$qg0$1@netnews.upenn.edu>

Andrew Hardy (nobody_at_spam.from.news.AdvanticaTech.com) wrote:
: No, you are looking for a SEQUENCE which you make auto-incrementing for your
: column by creating a before insert row TRIGGER.

I agree except that you can use (something like)

insert into table1
select (mysequence.nextval from dual) as uniqueid,

	value2,
	value3,
	value4

from tablea

instead of a trigger. I think that this is faster than the trigger.

Greg Received on Thu Sep 27 2001 - 15:49:26 CDT