Re: Loading a constant date using SQLLDR

jimit99_at_gmail.com wrote:
> Hello,
>
> I want to load a fixed date (5th March 2006) into a date column of an
> Oracle table through sqlldr
>
> The date is available in format 20060305.
>
> Have tried several options in the control file as follows but none seem
> to help:
>
> LOAD DATA APPEND INTO TABLE LOST_FEED
> ( REPORT_DATE CONSTANT '20060305') )
>
> LOAD DATA APPEND INTO TABLE LOST_FEED
> ( REPORT_DATE DATE TO_DATE('20060305','YYYYMMDD') )
>
> and many more combinations.
>
> Is there a way to load "20060305" directly into the column through
> sqlldr?
>
> TIA
>
> Jimit Shah
> Amdocs Inc.

If I understand what you're trying to achieve, try:

LOAD DATA
APPEND INTO TABLE LOST_FEED
( REPORT_DATE "to_date(:report_date,'YYYYMMDD')"

I'd also try reading up a bit more on SQL*Loader in the Utilities documentation.

HTH -g Received on Wed Mar 22 2006 - 19:00:49 CET