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).