Re: Insert into 2 tables at one time

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 18 Mar 2005 03:03:44 -0800 (PST)
Message-ID: <20050318110345.7694.qmail@web52601.mail.yahoo.com>

Just simple example:

insert into emp values (seq1.nextval, ....) returning empid into :somebind;
insert into dept values (..,:somebind, ...);

Regards,
Zoran

• Kean Jacinta <jacintakean_at_yahoo.com> wrote:
  > 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
  >
  

  ---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

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

Received on Fri Mar 18 2005 - 06:07:23 CST