RE: sql loader

Hi Radhika,

> I thought of that but because of some various other reasons I have to
> differentiate at the load process.

Surely this just make the suggestion Alroy made even more correct?

You are describing a solution as an algorithm so the best idea is load load the data into one work table and process it with sql in several passes or write a pl/sql module to do it.

regards
George.

> -----Original Message-----
> From: "Radhika Rao Putumbaka" <radhikaraop_at_hotmail.com>
> [mailto:radhikaraop_at_hotmail.com]
> Sent: Friday, May 05, 2000 4:04 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: Re: sql loader
>
>
> Hi,
>
>
> I thought of that but because of some various other reasons I have to
> differentiate at the load process.
>
> Text file contains data like this:
>
> COLUMN 1- RequestorName, 2- CustomerName,
> 3- Dir.No, 4- Switch, 5- LineType, 6- LineTypeValue.
>
> Now in one text file, I have one requestor & custname name
> with several
> records (> 200 or so.) of Columns 3, 4, 5, 6 of which some
> are parent and
> some are child values. This number of records can vary
>
> If Line type column has a value "HuntGroup" then I know its a
> parent record,
> and the following records are child records until I see
> another "Hunt Group"
> line type. what I want to do is assign a parent id for the
> first parent
> record I see and assign the child id's for child records and keep
> incrementing the related Id's as I see the next parent and
> child. But I do
> not know how to implement this condition in sql loader.
> Is this possible at all in sql loader.
>
> any ideas or suggestions are appreciated.
>
> regards
> Radhika.
>
>
>
>
>
> >From: Alroy Mascrenghe <mark_alroy_at_yahoo.co.uk>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: sql loader
> >Date: Fri, 05 May 2000 03:14:50 -0800
> >
> >Hi Radhika
> >
> > The easiest way would be to load the entire thing
> >into one temporary table using sql loader..etc. And
> >then write a PL procedure to insert the records into
> >the relevant tables after checkig the parent chiild
> >Relationship.
> >
> >Alroy
> >--- Rajagopal Venkataramany <rajagopalvr_at_hotmail.com>
> >wrote:
> > >
> >Hi all,
> > I have a COMMA DELIMITED text file, that has parent
> >records and child
> > records in the same text file. Now how do I
> >differentiate and relate a
> > parent record to a child record and insert the values
> >into either one or two
> > tables and still be able to identify the parent and
> >child records.
> > If somebody has gone through such load process, any
> >suggestions or an
> > example code from you are greatly appreciated.
> > thanks
> > Radhika.
> >
> >
> >____________________________________________________________
> >Do You Yahoo!?
> >Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> >or your free @yahoo.ie address at http://mail.yahoo.ie
> >--
> >Author: =?iso-8859-1?q?Alroy=20Mascrenghe?=
> > INET: mark_alroy_at_yahoo.co.uk
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access /
> Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ______________________________________________________________
> __________
> Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com

-- 
Author: Radhika Rao Putumbaka
  INET: radhikaraop_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may