How to create the correct date-time field?
Posted on 2014-09-16
I have a CSV file with a field like below:
"May 28 00:14:39","Event-001","This is error event"
I would like to load such files to an Oracle table using external tables. However I do not know which Oracle Data Type I'm going to create for the first field (which is May 28 ...) while creating table.
Note: I'll perform insert into oracle-table select * from external-table.