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