Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
11-05-2007, 06:01 AM #1
- Join Date
- Sep 2006
- India Mumbai
- Thanked 1 Time in 1 Post
ORACLE 9i:Executing multiple sql statments from a control file
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?