Data loading utility in Oracle APEX

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

1 2 3 4 5 6 7 8

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

9 10 12 11

Demo

#JoelKallmanDay JoelKallmanDay


comments powered by Disqus