Re: Sequence problem ~~

From: Stephan Herschel <stephan_at_proceryon.at>
Date: Wed, 16 Aug 2000 09:36:42 +0200
Message-ID: <399A448A.558787E5@proceryon.at>

Hi,
You can't assign the sequence to the column directly. Either you select the seq.nextval for every insert or you create yourself a trigger that does this for you.

regards,
Stephan

Chun-Yen wrote:
>
> Hello,theres
> I have a problem about sequence.
> For example,I have a sequence seq1 and a table
> test(c1 number,c2 varchar2(10)).
> Can I assign the sequence to the column c1's default value??
> Or I must "always" select the seq.nextval before insert a new row?
>
> Rgds,
> Agi Chen
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 16 2000 - 02:36:42 CDT