| clarification on sql loader [message #73267] |
Thu, 11 March 2004 23:32  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
hi,
i need a clarification on sql loader's features.
can the datafile which is feeded to the loader contain queries or sql functions in its
records instead of data so that the loader executes the queries and replace them with data
and later insert the records into the tables.
lets suppose the .dat file looks as follows
"sony",select entity from item where id==1
"ferrari", "car"
suppose that item is a table in the database with two coloumns(id,entity)which is already
filled.
can the loader execute the above query in the first record and replace it with data and then
load it in to the database . plz help me. regards
satish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
