load the date field from text file into oracle table
Hi,
How do I load the date field from the text file "Feb 22 17:16:52" into oracle table using sql loader ?
Table Script:
CREATE TABLE Bu1 ( KEY_ID NUMBER(6), DATE_FINISHED DATE, SERVER VARCHAR2(25));
Load.ctl:
load data
infile 'BackStop.dat'
badfile 'BackStop.bad'
discardfile 'BackStop.dsc'
append
into table bu1
TRAILING NULLCOLS
(key_id recnum,
date_finished to_date(DATE_FINISHED,'02/22/2011 17:16:52') CHAR TERMINATED BY WHITESPACE ===> some thing like this
server CHAR TERMINATED BY WHITESPACE)
Thanks in advance..