Re: SQL Insert question

  • From: "Don Seiler" <don@xxxxxxxxx>
  • To: oratips@xxxxxxxxx
  • Date: Thu, 17 May 2007 12:17:26 -0500

Look up the MERGE statement.

Don.

On 5/17/07, Bala <oratips@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: