Re: SQL*Loader

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 08 Mar 2002 06:49:10 +0100
Message-ID: <u0kg8u006h2793c9r7mu43bkf0fi9hatp8@4ax.com>

On 7 Mar 2002 17:56:06 -0800, botham_ian_at_hotmail.com (Ian Terence Botham) wrote:

>to_conversion_date DATE(10) "(select to_char((sysdate + 3),
>'MM-DD-YYYY') from dual)",
>but this is failing...don't know why...

Could you PLEASE ........... RTFM ???????? (Oracle Server Utilities manual, that is)

You DON'T NEED the SELECT per the FM you can just ASSIGN ":sysdate+3" to that to_conversion_date column.

You are very stubborn in not RTFM, aren't you???

Hopefully you are not developing a commercial app, but just some toy.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 07 2002 - 23:49:10 CST