O'Reilly logo

Oracle APEX Cookbook - Second Edition by Marcel Van Der Plas, Michel Van Zoest

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a data upload page

Since Version 4.0, APEX offers the possibility to create a Data Upload wizard. This wizard is actually a visual representation of SQL Loader. But now you can import data from spreadsheets in a user-friendly way. In this recipe we will show you how easy and powerful this Data Upload wizard can be. We will create a page where a user can upload dealer address data.

Getting ready

Make sure you have access to the app_dealers table and that you have an .csv file and an .xls file with the following layout:

DLR_NAME
DLR_ADDRESS
DLR_CITY
DLR_STATE
DLR_COUNTRY_CD

We enclosed two sample files along with this book.

How to do it...

  1. In the Application Builder, click on Create Page.
  2. In the User Interface radio group, select Desktop.
  3. Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required