Sequence problem ~~
From: Chun-Yen <agi_at_haa.com.tw>
Date: Wed, 16 Aug 2000 06:09:34 GMT
Message-ID: <8ndb6l$pn3$1_at_nnrp1.deja.com>
Date: Wed, 16 Aug 2000 06:09:34 GMT
Message-ID: <8ndb6l$pn3$1_at_nnrp1.deja.com>
[Quoted] 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 - 08:09:34 CEST