SQL*Loader

Hi

I want to load some records (of data) into Oracle conditionaly, based on the value present in one of the tables.

Eg,

 Assume, there are two tables in the DB to store

1. Name and Name ID (which is unique), ( NAME TABLE)
2. Location and Location ID. ( LOCATION TABLE)

 Now i want to load the following record in a third table  as the Name ID, Location Id and Age.

 //Name         Location     Age  (structure of the record)
   Vikram kumar  Madras       48

 This requires querying the name and location table to get the corresponding ids before the record is loaded into the DETAIL table.

Can this be possible with SQL*Loader?

If SQL*Loader doesn't support this, i am thinking to get all data to a temporary table and process it from there.

Pls. reply if any alternate efficient method is there.

Thanks
Nandakumar

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu May 27 1999 - 16:49:30 CDT