Insert into 2 tables at one time

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Fri, 18 Mar 2005 02:16:51 -0800 (PST)
Message-ID: <20050318101651.92196.qmail@web52905.mail.yahoo.com>

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

Received on Fri Mar 18 2005 - 05:20:25 CST