Home » RDBMS Server » Server Utilities » How can the SQL loader handle self referential tables?
How can the SQL loader handle self referential tables? [message #225957] Thu, 22 March 2007 01:57 Go to next message
Messages: 5
Registered: January 2007
Junior Member
If I have a lookup table like this:
(ID (sequence column),
PARENT (self referring column, refers to ID),
DESC etc)

how can I specify the correct value for the PARENT column in a .ctl file without reading it from a data file? Is there an option where both the ID and the PARENT column can be dynamically specified in the control file?

I didnt find anything on

Thanks in advance.
Re: How can the SQL loader handle self referential tables? [message #226014 is a reply to message #225957] Thu, 22 March 2007 05:26 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Do you want to dynamically generate values for PARENT and ID or
or what?
Did you try with sequence parameter?
or try this method (usually used for parent/child tables). But the concept is same.

Right now, i dont have access to database else i would have tried it.
Previous Topic: export of one database and import into other database
Next Topic: SQL*Loader Help.
Goto Forum:

Current Time: Mon Aug 21 03:36:58 CDT 2017

Total time taken to generate the page: 0.02331 seconds