Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Sequence problem ~~
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