Oracle SQL SQL*Loader :Issues
Issue: how can load data date format 1/3/1987 in oracle by the sql loader?
Resolution:
If input date is in default database format then sql*loader will load it
with out issues. Otherwise we will have to convert it into right format.
An example would b
be
LOAD DATA
INTO TABLE DATES (COL_A POSITION (1:15) DATE "DD-Mon-YYYY")
BEGINDATA
1-Jan-1991
1-Apr-1991
in other cases
LOAD DATA
INTO TABLE DATES (COL_A POSITION (1:15) DATE "DD/MM/YYYY")
BEGINDATA
1/3/1987
