Home » RDBMS Server » Server Utilities » SQL*Loader help on populating fields with data lookup
SQL*Loader help on populating fields with data lookup [message #368163] Tue, 19 September 2000 04:16 Go to next message
Jaipal
Messages: 2
Registered: September 2000
Junior Member
I need help with using SQL*Loader. I need to populate a flat file into an oracle table. Unfortunately, the file contains foreign keys to tables already loaded in the database. How can I do a lookup of these foreign keys and populate the keysalong with the data in the flat file into a new table.

I hope someone can help me out here.

Thanks in advance.

Jaipal

Report message to a moderator

Re: SQL*Loader help on populating fields with data lookup [message #368178 is a reply to message #368163] Fri, 22 September 2000 10:50 Go to previous message
Alan
Messages: 68
Registered: October 1999
Member
I have the same situation. I couldn't find any SQL*Loader options to perform this so I just created a PL/SQL script and used the UTL_FILE package. Before I did this I played around a little with using a BEFORE INSERT trigger but decided to use the procedure instead.

Report message to a moderator

Previous Topic: Datafile path hardcoded in Dump file.
Next Topic: changing character sets
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 28 18:06:09 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.