Search code examples
oracle-apexoracle-apex-5oracle-apex-5.1

How to upload text/csv file data without column mapping on Oracle Apex?


I have created a table on oracle apex which has almost 50 columns. I want to upload csv or comma/tab separated text data file without column mapping. All I need auto column mapping. Is there any way to accomplish that?

Thanks


Solution

  • There's none.

    Data loader, once you create it using the Wizard & run the page, suggests "do not load" as a target for all columns.

    If you look at Shared Components / Data Load Definitions, you won't find any settings that would suggest something like "map fields sequentially". Furthermore, none of region attributes nor properties contains anything like that.

    As far as I can tell, that can't be done in a declarative manner.