Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL Insert question

Re: SQL Insert question

From: Don Seiler <don_at_seiler.us>
Date: Thu, 17 May 2007 12:17:26 -0500
Message-ID: <716f7a630705171017t15732811j3eb7ec76b5c1d1ad@mail.gmail.com>


Look up the MERGE statement.

Don.

On 5/17/07, Bala <oratips_at_gmail.com> wrote:
> --
> EMPLOYEE table ( no constraints defined) has currently 1000 records.
> How to insert extra 100 Records based on one existing record and change
> EMPNAME column only based on the List of 100 EMPNAMES i have ?--
> --
> Thanks for any and all ideas.
>
> Bala Rao

-- 
Don Seiler
oracle blog: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 17 2007 - 12:17:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US