Hello
This is Charitha
i am using a sequence to generate primary key column in emp table
but i am uing that in this fashion n1.dept_id||seq.nextval into emp_id
( i.e dept_id + sequence no becomes the employee id )
and i have child table also
in that child table i need to insert this manually generated emp_id into child table emp_id(referenced column )
how to insert
please let me know
Thank you