View Full Version : ORACLE 9i:Executing multiple sql statments from a control file

Nov 5th, 2007, 06:01 AM
hi all,
i am loading data by running a .ctl file. everytime the ctl file is run, it first truncates all the records and loads the fresh data from a csv file. now what i want is, it should count the number of records that are previously there in the table and store the count(*) in different table and then proceed for the truncation. how can it be done?