Overview
This document explains how to load from XML file into table using Data loading facility in Oracle Apex 21.1.1.
Technologies and Tools Used
The following technology have been used to achieve this in oracle apex.
- Oracle Apex 21.1,1.
Use Case
- We can load data not only CSV files but also JSON, XML and XLSX file into table in the Apex.
- Data can be loaded into a new tables as well as existing tables.
- Data can be loaded by using Data Workshop in Oracle Apex.
Steps
Steps to be followed.
Step1: To access the Data Workshop.
Step2: Upload a File/Copy and Paste.
Step2: Load to New table/ Existing Table.
Data Loading
To access the Data Workshop
Step 1: To access the data workshop: SQL Workshop > Utilities > Data Workshop.
You will have the page as shown as below. Click on Load data
Upload a File/Copy and Paste
You will have the below page after clicking on “Data Load”. There are two options for loading data. They are Upload a file and Copy and Paste option. If you have XML data then go for Upload a file option. I you have data in txt file then go for Copy and Paste option. Here, we are going to load data from an XML file so let us go with Upload a File option.
Load to New Table/ Existing Table
After uploading the file we will have the page as shown as below. As I said earlier, we can load data into a New Table or an Existing table. Please select table if you are going to upload data into an existing data but make sure that your existing table column names and XML column names should be same.
Please give table name if we are going to upload data into new table. I have given table name as “EMPLOYEES” and then click Load Data button. I have the below data in XML file.
These data will be loaded into the Employee table with primary key ID column. ID column will be created automatically with a sequence in Oracle Apex when we upload data into a new table. Please refer the below screenshot for your reference.
Data has been uploaded into Employees table as shown as below.
