Home » RDBMS Server » Server Utilities » Select statement in SQL * Loader
Select statement in SQL * Loader [message #72868] Tue, 25 November 2003 06:04 Go to next message
Raja
Messages: 57
Registered: March 2000
Member
Can we use select statements in SQL*LOADER to insert some column values from
other tables?

Can we use in the .ctl file, to pick the values from a column of another value?

Report message to a moderator

Re: Select statement in SQL * Loader [message #72871 is a reply to message #72868] Thu, 27 November 2003 05:08 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

> Can we use select statements in SQL*LOADER...

No, but you can write a function (with embedded SELECT statements) and use its return value in SQL*Loader - see http://www.orafaq.com/faqloadr.htm#MODIFY for details.

Note however that this method can only be used with conventional loads - not supported with direct path loads.

Best regards.

Frank

Report message to a moderator

Previous Topic: Oracle Error 01401 on Import
Next Topic: copy the contents into CLOB datatype
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 06:41:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.