String to Date or TO_DATE as a function in OIC

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

MSG Entertainment LLC

Description (Required):

I was surprised to know that there is no function in OIC to convert incoming string to date. If incoming data has a date as character value which needs to be assigned to a variable which is a date datetype, it is becoming increasingly difficult to achieve this task.

Use Case and Business Need (Required):

We came across this requirement when we load the data from a csv file onto a database table in which one of the columns accepts only date format. The incoming file has date format as DD-MON-YYYY and while uploading this data to OIC if we had function similar to TO_DATE, it would have been much simpler to transform and load the data.