Re: SQL*Loader

From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 07 Mar 2002 21:37:10 GMT
Message-ID: <a4Rh8.11682$Gu6.5218893@typhoon.san.rr.com>

Prasad's comment is very valid but the answer to your basic question is yes. You need to put parenthesis around the select for it to work though...

to_conversion_date "(select to_char(SYSDATE,'MM-DD-YYYY') from dual)",

Think of the expressions you put in quotes as being in the 'SELECT' clause of a query.

Richard

Ian Terence Botham wrote:
>
> Can I call a select satement in the SQL*Loader control file..
> Like for example...
>
> LOAD DATA
> APPEND INTO TABLE xx
> (
> from_conversion_date DATE(10) "MM-DD-YYYY",
> to_conversion_date "select to_char(SYSDATE,'MM-DD-YYYY') from dual",
> )
>
> I am referring to the select statement in the second column..
>
> I tried these but am getting unusual errors.. like missing expression,
> missing right parantheses when everything seems fine...
>
> Which drives me to the very question whether select statemets like the
> above are welcome in SQL*Loader.....or how else would one enter
> sysdate or tomorrow's date through sql*loader...
>
> Thanks
> Ian.............
Received on Thu Mar 07 2002 - 15:37:10 CST