Re: SQL*Loader

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 07 Mar 2002 23:03:41 +0100
Message-ID: <eqof8ugp3m3sogiegeujl0ce8rf8rt3e17@4ax.com>

On 7 Mar 2002 12:24:19 -0800, botham_ian_at_hotmail.com (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.............

The select is unnecessary as you can in your CREATE TABLE statement DEFAULT a column to SYSDATE, as you can do in SQL*Loader.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 07 2002 - 16:03:41 CST