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