RE: Insert into 2 tables at one time

 
check out the Oracle SQL reference (and/or read my book :-)
once you have selected NEXTVAL from an Oracle sequence, 
you can use CURRVAL in that same session to refer to the same sequence value ...
kind regards,

Lex.
 
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Kean Jacinta
Sent: Friday, March 18, 2005 11:17
To: oracle-l@xxxxxxxxxxxxx
Subject: Insert into 2 tables at one time

Hello 

Need some help on this. I have 2 table


Emp
----------
empid   (running on oracle sequenceno)
empname
deptid

Dept
----------
deptid
empid
deptname

I need to insert into emp table first and then get seqid just created and insert
into dept table. Would it be possible to do tat ?







                
__________________________________
Do you Yahoo!? 
Make Yahoo! your home page
http://www.yahoo.com/r/hs
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Other related posts: