Hello experts,
We're trying to create an external table with a single datafile feed and fixed positions.
Each record, depending on the first field, must be substringed with different lengths.
In SQL*Loader, there was a possibility to add to a single ctl several WHEN clauses to parse the same file and apply different substrings depending on the conditions, but we're unable to reproduce the same behavior with external tables.
Is it possible and if so, could you please provide us with an example?
Thank you all for your time and help.
Kind regards