Re: Loading a constant date using SQLLDR
- From: Sybrand Bakker <gooiditweg@xxxxxxxxxxxxxxx>
- Date: Sat, 18 Mar 2006 06:45:59 +0100
On 17 Mar 2006 21:02:15 -0800, jimit99@xxxxxxxxx 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 DBA
.
- References:
- Loading a constant date using SQLLDR
- From: jimit99
- Loading a constant date using SQLLDR
- Prev by Date: Loading a constant date using SQLLDR
- Next by Date: Re: Oracle Client Tool for a developer
- Previous by thread: Loading a constant date using SQLLDR
- Next by thread: Re: Loading a constant date using SQLLDR
- Index(es):
Relevant Pages
|
|
