How to assign a seq while creating a table
457512Dec 23 2005 — edited Dec 26 2005Hi,
How to assign a sequence such that i dont want to give the sequence while creation. i mean
if employee table is there
sl_no empname salary .....
i dont want to give sequence while inserting the data, i want to give the sequence at creation of table level for sl_no
i tried this
create table seqtest1 (id number primary key default rajseq.nextval);
but it is showing me the error
ERROR at line 1:
ORA-00907: missing right parenthesis
whats the solution
please help me
Thank you
Raj deep.A