From the course: Oracle APEX: Foundations

Unlock this course with a free trial

Join today to access over 23,300 courses taught by industry experts.

Sample datasets

Sample datasets

(dramatic sound) - Welcome to the Oracle Apex Foundations course. Today in this lesson on using SQL Workshop, I'll be talking about Data Workshop and Sample Datasets. Let's get started. In this section, you'll learn how to load and unload data, using the Data Workshop. You'll also learn how to access sample datasets in Apex. Use the Data Workshop page to load data into your workspace from various file formats such as XLSX, CSV, XML and JSON. Use the Load Data Wizard to load from various file formats into your workspace and Unload Data Wizard to export your data in text or XML format. Now let us look at the steps to access the Data Load or Unload page. From your Apex Workspace homepage, click the down arrow next to SQL Workshop and select Utilities, select Data Workshop. The Data Workshop page appears. You can click Load Data to load data into your workspace and Unload Data to export data from your workspace.…

Contents