Re: Loading a constant date using SQLLDR
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 18 Mar 2006 06:45:59 +0100
Message-ID: <aj7n12pohi1a75skpp7q7nhnglfrv99pc5_at_4ax.com>
Date: Sat, 18 Mar 2006 06:45:59 +0100
Message-ID: <aj7n12pohi1a75skpp7q7nhnglfrv99pc5_at_4ax.com>
On 17 Mar 2006 21:02:15 -0800, 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.
Which direct ways are you expecting apart from the *direct* ways above, and why do you think they don't work.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Mar 18 2006 - 06:45:59 CET