Re: Newbie question: How to add auto number...

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 15 Sep 1999 19:50:15 -0400
Message-ID: <g4WD3.90$A3.155@news.ipass.net>

I agree with the first post. You can make it automagic by doing the "SELECT sequence_name.nextval INTO :NEW.column_name FROM dual" in a BEFORE INSERT trigger.

Regards,
--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original modern rock? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult
Raleigh music compilation! All $$$ go to NC Food Bank. http://www.mp3.com/whisper2ascream

Jack Chen wrote in message ...
>Hi,
>
>Sorry for asking this question, this is my first day on Oracle.
>
>How to make the first column(such as 'User_ID')add an auto number, it was
>very easy in Access and SQL.
>
>Thanks
>
>Jack
Received on Wed Sep 15 1999 - 18:50:15 CDT