Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Load date in 'MM/DD/YYYY' format by SQL*LOADER
I have a data file that date in 'MM/DD/YYYY' such as '10/11/2000'. I am
trying to use sql loader to load the file into table.
I wrote the control file including:
AVAILABILITY_DT DATE NULLIF AVAILABILITY_DT="00000000"
However, oracle can not take it. I did try to chang control to :
AVAILABILITY_DT DATE 'MM/DD/YYYY' NULLIF AVAILABILITY_DT="00000000"
It dosen't work either.
So how can I modify the control file in order to take the date like
'MM/DD/YYYY' ?
Please help.
Received on Mon Oct 16 2000 - 18:02:07 CDT