Data loading utility in Oracle APEX

COLLECTION

• Step 1: Create Data Loading Definition
• Step 2: Select Target Type (COLLECTION Name- DATA_LOADING)
• Step 3: Sample Data Mapping (Source Type – Upload a File/Copy and Paste)
• Step 4: File Size and Data definition selection
• Step 5: Create a page using the Data Definition for loading

Sample Data

Loading into Table

Create a table for loading data.

Create table data_loading_table
(
	ename varchar2(100),
	salary number
);

• Step 1: Create Data Loading Definition
• Step 2: Select Target Type (Table Name- data_loading_table)
• Step 3: Sample Data Mapping (Source Type – Upload a File/Copy and Paste)
• Step 4: File Size and Data definition selection
• Step 5: Create a page using the Data Definition for loading

Demo

#JoelKallmanDay