| Very Urgent - SQL LOADER, DATE PROBLEM [message #73137] |
Thu, 12 February 2004 23:53  |
Govind
Messages: 2
Registered: February 2004
|
Junior Member |
|
|
Hi Pals,
I have a problem here,
Table name : upld_table
dlt_BYTE VARCHAR2(2)
sat_ID VARCHAR2(10)
dt_ENTERED DATE
I have following data in sat.dat
0001022363+20020109
0001022590+20020109
0001022610+20020102
0001027868+20020118
0001027970+20020118
I would like to upload through SQL loader to my table upld_table
Please Help me to write a control file.
Its very urgent
|
|
|
|
| Re: Very Urgent - SQL LOADER, DATE PROBLEM [message #73139 is a reply to message #73137] |
Fri, 13 February 2004 00:26  |
nabila mekkaoui
Messages: 5
Registered: March 2003
|
Junior Member |
|
|
LOAD DATA
INFILE 'sat.dat'
INTO TABLE upld_table
REPLACE
TRAILING NULLCOLS
(dlt_BYTE position(1:2) CHAR NULLIF (dlt_BYTE=BLANKS)
, sat_ID position(3:11) CHAR NULLIF (sat_ID=BLANKS),
dt_ENTERED position(12:19) DATE "RRRRMMDD" NULLIF (dt_ENTERED=BLANKS)
)
|
|
|
|
|
|
| Re: Very Urgent - SQL LOADER, DATE PROBLEM [message #73315 is a reply to message #73156] |
Mon, 22 March 2004 23:09 |
Azzah Al-Sayegh
Messages: 3
Registered: June 2002
|
Junior Member |
|
|
I have a problem with the loading of the following date by using SQL*Loader
Date: "02/29/1403" in format "MM/DD/YYYY"
The date is a valid Hijra date but the oracle date format is Gregorian, therefore this year "1403" is considered as not a leap year and day "29" is invalid day, so this record is rejected during the loading
I can't change NLS_DATE_FORMAT because my data file contains mix of dates' format (Hijra & Gregorian)
Can I change the format of date for each column in the control file of SQL*Loader
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
