Now,i created a table with the following structure.
create table tab1(eno number,ename varchar2(10));
Now,i want the eno in tab1 to refer the sequence seq1.I can't able to get this.Please,suugest me a solution on how i have to do this.
Thanks in Advance, regards, Siva Sankar
Joined: Mar 17, 2006
You will have to use TRIGGERS if you'd like to insert the value automatically, while inserting a new row; else you will have to explicitly fetch the next sequence and insert it along with the other values.
Hope this helps....
"What's in a name? That which we call a rose by any other name would smell just as sweet."<br />(William Shakespeare, Romeo and Juliet, Act II, Scene II)