5.1.5 Loading Data
Use the Load Data Wizard to copy and paste or upload data.
- About Loading Data
Load data into the Oracle APEX by copying and pasting CSV data, selecting a sample data set, or uploading a file. - Copying and Pasting CSV data or Selecting a Sample Data Set
You can copy and paste CSV data, or select a sample data set sample into the Load Data Wizard. - Loading an XML Document
Load an XML document using Load Data Wizard. - Loading a JSON File
Load a JSON file using Load Data Wizard. - Loading a XLSX File
Load a XLSX file using Load Data Wizard.
See Also:
Parent topic: Using Data Workshop
5.1.5.1 About Loading Data
Load data into the Oracle APEX by copying and pasting CSV data, selecting a sample data set, or uploading a file.
Key capabilities when loading data into the APEX include:
- Copy and paste CSV data, or select a sample data set.
- Upload a file (supports CSV, XLSX, TXT, XML or JSON files).
Note:
Configure load settings such as column headers, file encoding, column delimiter / enclosed by (for CSV or TXT), and Select Sheet (for XLSX with multiple worksheets).
- View full preview and change more settings by clicking Configure button. Configure dialog displays maximum of 100 columns and 100 rows. You can configure same setting as settings in the main dialog plus maximum Rows to Sample and columns to load/unload.
- In Configure dialog, under Columns to Load tab, you can enter case insensitive value that will be treated as
NULL
. For example,"tbd"
,"n/a"
,"unknown"
,"-"
. - Post loading, if any rows fail, up to 10 rejected rows display. To view more rows which have error, click Open in Object Browser button. You can optionally click Drop Table and Reload button to try the data load again.
- Settings change will change preview both in main and configure dialogs. They also affect data load result.
- Select table owner, enter table name and error table name
Note:
By default, all table names are converted to upper case. If data load succeeds without any error, the error table is dropped automatically. - Post loading, a View Table button and Continue to Create Application Wizard button display if there are no failed rows. The load is successful if ta table is created and displayed.
Parent topic: Loading Data
5.1.5.2 Copying and Pasting CSV data or Selecting a Sample Data Set
You can copy and paste CSV data, or select a sample data set sample into the Load Data Wizard.
To load data by copying and pasting CSV data or selecting a sample data set:
Parent topic: Loading Data
5.1.5.3 Loading an XML Document
Load an XML document using Load Data Wizard.
XML files can also be uploaded to Oracle APEX. However, APEX only supports flat XML structures which can easily be mapped to a table and columns. XML structures with multiple levels of nesting cannot be loaded by the Data Loading wizard.
To load an XML document:
Parent topic: Loading Data
5.1.5.4 Loading a JSON File
Load a JSON file using Load Data Wizard.
Loading JSON files works similar to loading XML files.
Note:
Only flat structures are supported - deeply nested JSON structures cannot be loaded.
To load a JSON file:
Parent topic: Loading Data
5.1.5.5 Loading a XLSX File
Load a XLSX file using Load Data Wizard.
Loading XLSX files is similar to loading CSV files. There is no need to detect or to choose delimiter or enclosing characters.
To load a XLSX file:
Parent topic: Loading Data