prompt PL/SQL Developer import file prompt Created on Monday, November 23, 2009 by kesavachaitanya set feedback off set define off prompt Disabling triggers for EMP... alter table EMP disable all triggers; prompt Deleting EMP... delete from EMP; commit; prompt Loading EMP... insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (3333, 7, 1, -130.6, 67.66, null); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (3333, 7, 2, 0, 67.66, null); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (3333, 7, 3, -130.6, 67.66, 'INV1'); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (44444, 8, 1, 1, 1, null); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (44444, 8, 2, -1, 1, null); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (44444, 8, 3, 0, 1, 'INV2'); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (55555, 2, 1, 4, 1, null); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (55555, 2, 2, 24, 1, null); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (55555, 2, 3, 24, 1, 'INV3'); insert into EMP (EMPID, MAIN_SEQ, DEATILSEQ, AMOUNT, EXCHANGERATE, INVOICE_ID) values (3333, 7, 4, 1, 68.9, null); commit; prompt 10 records loaded prompt Enabling triggers for EMP... alter table EMP enable all triggers; set feedback on set define on prompt Done.