use inserted value dynamically at the run time

[P J S]

Hi,

I am inserting a new record into a 'master' table. Primary key is generated using a sequence. Now using that newly inserted primary key value, I need to insert a new record in child table. These 2 insert queries need to run at the time of deployment.

My question is, how shall I store that primary key in a variable so that I can use it immediately in next insert statement?

Can I use a returning into clause?
Please help...

-P J S

 

[P J S]

Its done
I used returning into clause..
Thanks..

-P J S