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