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