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