Re: sql loader

From: Alroy Mascrenghe <mark_alroy_at_yahoo.co.uk>
Date: Fri, 5 May 2000 11:10:08 +0100 (BST)
Message-Id: <10488.105031@fatcity.com>

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 Received on Fri May 05 2000 - 05:10:08 CDT