Re: SQL Loader - insert into multiple tables

Arvind,


I suggest using grep to generate the two files which can then be loaded as
required.


Russell

On 12/7/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

Cmp,cs001,29

Cln,cs002,08,Y

Cmp,cs002,65

Cmp,cs002,80





     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 ?







Thanks

*Arvind Kumar*

Associate  Consultant
Siemens Information Systems Limited
e-mail : *arvind.kumar2@xxxxxxxxxxx*



Other related posts: