Re: SQL Loader - insert into multiple tables

you need two files and two control files

On 07/12/06, Kumar, Arvind IN GGN SISL <arvind.kumar2@xxxxxxxxxxx> wrote:

 Hi Friends,

       I  have a  text datafile in the following format

Cln,cs001,04,Y

Cmp,cs001,45

      Now i want to load all the records starting with  'CLN' into table1
and all the records starting with 'CMP' into table 2 using sql loader, what
would be control file ?

Other related posts: