Re: SQL*Loader

From: Prasad Yarlagadda <prasad.yarlagadda_at_motorola.com>
Date: Thu, 7 Mar 2002 15:12:11 -0600
Message-ID: <a68l3b$la02@nntp.cig.mot.com>

You can use just SYSDATE, rather than the select statement. That works fine without any select.

to_conversion_date SYSDATE

If you want to specify format, use to_date.

to_conversion_date "to_date(:XYZ_DATE, 'MM-DD-YYYY')"

Prasad

"Ian Terence Botham" <botham_ian_at_hotmail.com> wrote in message news:709f185b.0203071224.11ab9eec_at_posting.google.com...
> 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:12:11 CST