Oracle Apex - Create Button,select and Upload file from CSV into APEX Table, Display in the application page

Question

I am new to Apex development, I want to add a button to an existing page on Apex. This button should be able to browse a file(.CSV), the data from the .csv should get inserted to the Apex table.

Can anyone please provide me the steps and the scripts to achieve this? Thank you.

Answer 1

Go to "Create page". Among all page types, you'll notice the Data loading type so - select it. Follow the Wizard.

The result will be 4 pages that are called one after another, and will let you do what you're doing.