Can anyone please give me the syntax for using a sequence in the values clause of an insert statement :
insert into table1(id)
values (select seq.nextval from sys.dual)
the above is not correct syntax.
+ Reply to Thread
Results 1 to 4 of 4
Click Here to Expand Forum to Full Width