RE: SQL Insert question

Sounds like a job for a good text editor. May I suggest Ultraedit from www.idmcomp.com.

______________________________________________________________
Dick Goulet / Capgemini
North America P&C / East Business Unit
\Senior Oracle DBA / Outsourcing
Office: 508.572.1978 / Mobile: 508.742.5795 / www.capgemini.com
Fax: 508.229.2019 Email: richard.goulet@capgemini.com
45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience
______________________________________________________________

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Bala
Sent: Thursday, May 17, 2007 11:13 AM
To: oracle-l
Subject: SQL Insert question

--
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

RE: SQL Insert question

Richard J. Goulet

2007-05-17