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 <http://www.capgemini.com/> Fax: 508.229.2019 Email: richard.goulet@xxxxxxxxxxxxx 45 Bartlett St. / Marlborough, MA 01752 Together: the Collaborative Business Experience ______________________________________________________________ ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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