Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

load the date field from text file into oracle table

user12025942Feb 22 2011 — edited Feb 23 2011
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..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2011
Added on Feb 22 2011
7 comments
1,140 views