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
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-27.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-28-1024x426.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-29-1024x561.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-30-1024x558.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-31-1024x558.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-32-1024x559.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-33-1024x224.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-34-1024x351.png)
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
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-35-1024x560.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-36-1024x561.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-37-1024x308.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-38-1024x329.png)
#JoelKallmanDay
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-39.png)