Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Load date in 'MM/DD/YYYY' format by SQL*LOADER

Load date in 'MM/DD/YYYY' format by SQL*LOADER

From: Maggie <maggiezhou_at_hotmail.com>
Date: Mon, 16 Oct 2000 16:02:07 -0700
Message-ID: <8sg1di$8f6$1@web1.cup.hp.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US