RE: Insert into 2 tables at one time

You can do it in one statement with something called a multi table insert.

INSERT ALL
INTO emp (empid, empname,deptno)
    VALUES (seq_emp_id.nextval, :empname,:deptno)
INTO dept (deptid,empid,deptname)
    VALUES(:deptid, seq_emp_id.currval, :deptname);


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kean Jacinta
Sent: Friday, March 18, 2005 5:17 AM
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: