Re: SQL Loader - insert into multiple tables - oracle-l - FreeLists

Re: SQL Loader - insert into multiple tables

From: "David Sharples" <davidsharples@xxxxxxxxx>
To: arvind.kumar2@xxxxxxxxxxx
Date: Thu, 7 Dec 2006 12:01:28 +0000

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 ?

Follow-Ups:
- RE: SQL Loader - insert into multiple tables
  - From: Davey, Alan

References:
- SQL Loader - insert into multiple tables
  - From: Kumar, Arvind IN GGN SISL

Other related posts:

» SQL Loader - insert into multiple tables
» Re: SQL Loader - insert into multiple tables
» Re: SQL Loader - insert into multiple tables
» RE: SQL Loader - insert into multiple tables
» Re: SQL Loader - insert into multiple tables