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:
1. Click the Create Page > button:
2. Select Data Loading and click Next >:
3. Enter the Data Load Definition Name; select the Owner, Table Name, and the required Unique Column fields. Click Next >:
4. You have the ability to add lookups and transformation rules if required. For this example, leave the settings as default, and click Next > on the Table Lookups and Transformation Rules pages:
5. Review the data...
