Loading a constant date using SQLLDR
From: <jimit99_at_gmail.com>
Date: 17 Mar 2006 21:02:15 -0800
Message-ID: <1142658135.676835.193040_at_v46g2000cwv.googlegroups.com>
Hello,
Date: 17 Mar 2006 21:02:15 -0800
Message-ID: <1142658135.676835.193040_at_v46g2000cwv.googlegroups.com>
Hello,
[Quoted] [Quoted] 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.
Received on Sat Mar 18 2006 - 06:02:15 CET