Creating the Upload interface
Before APEX 4.1, uploading CSV files into an Oracle database using APEX was very manual. With the latest release, APEX has built-in functionality to cater for the uploading and parsing of CSV files into an Oracle database.
Getting ready
Log on to APEX and open the application.
How to do it...
Creating the upload interface in APEX 4.1 is significantly easier than in previous versions. One of the most common requests in a data warehouse is the ability for end users to upload data from a CSV file. In APEX 4.1, this is the default functionality:
- Click the Create Page > button:
- Select Data Loading and click Next >:
- Enter the ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
