Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader control file default values

Re: SQL*Loader control file default values

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 25 Aug 2002 23:35:03 +0200
Message-ID: <ebjimu0flvl50169v1j5nj9kggpvffgfn1@4ax.com>


On 25 Aug 2002 19:33:52 GMT, bvince2172_at_aol.comPRO (BVince2172) wrote:

>How can I specify the current date as a default value for a field, if the
>relevent field in the incoming data file is actually null?
>
>On a similar note, is it possible to truncate an incoming varchar2 if it's over
>a certain length?

alter table foo modify date_column default sysdate

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Aug 25 2002 - 16:35:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US