Re: How to generate new record number

From: David K. Van Zandt <dvanzandt_at_iquest.net>
Date: 1998/03/16
Message-ID: <350DEFD1.E4CD1ED3@iquest.net>#1/1

This works: INSERT INTO sometable rec_ID, somecolumn VALUES (sequence_name.nextval, 'somevalue'). The Oracle SQL manual is pretty easy to read on this....

Kind regards,
Dave

Yuan Wei wrote:
>
> Hi everyone out there,
>
> I have actually created a sequence for some transaction, the question is how
> am I going to integrated into my system, so that every time a new record
> created will have a new transaction number....
>
> pls help...
>
> Your help will be greatly appreciated....
>
> thanks!

-- 
Dave Van Zandt
(work) david.vanzandt_at_alcoa.com
(pers) dvanzandt@iquest.net  http://members.iquest.net/~dvanzandt

Received on Mon Mar 16 1998 - 00:00:00 CST