Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL Insert question
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-lReceived on Thu May 17 2007 - 12:17:26 CDT
![]() |
![]() |