Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL Loader - insert into multiple tables

SQL Loader - insert into multiple tables

From: Kumar, Arvind IN GGN SISL <arvind.kumar2_at_siemens.com>
Date: Thu, 7 Dec 2006 17:24:05 +0530
Message-ID: <DB870BED06C39D4DBD5FCB1BD9C856D40788C72A@inggnh999msx.in002.siemens.net>


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_at_siemens.com  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 07 2006 - 05:54:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US