Hello everyone. We use Oracle 11R1. We have an external table pointing to a csv file with 7 columns in it. The file always has 7 column but order of those columns differs from time to time. Each column has a header which stays consistent. Is there a way to map column names to those column header,s so that we do have to change external table definition each time a new file comes in?
Thank you.