The filenames look like YYYYMMDD_filename.csv
A file contains 2 fields separated with ;
Is there a way to extract the date from the filename and write this date into a third column of the resulting external table.
BTW the second field in the files are integers. At the moment I import them as VARCHAR2 respectively char. What would be more convenient that they would be imported into a NUMBER column ?
I'm using oracle db 21c xe