Total Pageviews

November 9, 2016

11/09/2016 11:04:00 PM
 Oracle SQL SQL*Loader :Issues
Oracle Sql*Loader

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 

0 comments:

Post a Comment