| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sql loader
Hi Radhika,
If your input file has the Parent and Child columns by which we establish the relation, then in your control file for sql loader you can specify it to load to the parent table where Parent column is null and to the child table otherwise.
This is what I can suggest since we do not have any inputs on the input file structure...
Regards
Rajagopal Venkataramany
----Original Message Follows----
From: "Radhika Rao Putumbaka" <radhikaraop_at_hotmail.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: sql loader
Date: Thu, 04 May 2000 12:19:27 -0800
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.
-- 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 also send the HELP command for other information (like subscribing).Received on Thu May 04 2000 - 15:19:34 CDT
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
 |
 |