<div>
How shall I define this &quot;to_date&quot; in create table statement?
</div>


How shall I define this "to_date" in create table statement?

<div>
In other words will external table read this field correctly with type DATE?
</div>


In other words will external table read this field correctly with type DATE?

<div>
You're welcome. Don't hesitate to come back in case you need further help ;-)
</div>


You're welcome. Don't hesitate to come back in case you need further help ;-)

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I have a CSV file with a field like below:<br />
<br />
&quot;May 28 00:14:39&quot;,&quot;Event-001&quot;,&quot;Thi<wbr />s is error event&quot;<br />
<br />
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. <br />
<br />
Note: I'll perform &nbsp;insert into oracle-table select * from external-table. &nbsp;<br />
<br />
BR
</div>
</div>


Dear Experts,

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.  

BR

How to create the correct date-time field?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.