RE: Insert into 2 tables at one time
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <jacintakean@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Mar 2005 11:26:37 +0100
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
