Installing a Sample Dataset

In addition to working with built-in sample data, you can also install additional sample datasets that include multiple tables related to a functional area.

Each sample dataset contains one or more tables with sample data related to the following use cases:

• Countries – Countries, populations, and capitals

• Customer Orders – Customers, stores (with longitude/latitude), products, and orders

• EMP / DEPT – The venerable EMP and DEPT tables with employees and departments

• HR Data – Human Resources tables used by Oracle Education

• Health Updates – Patient health status updates

• Project Data – Projects, milestones, and tasks

• Tasks Spreadsheet – Spreadsheet-like table with tasks, dates, status, assignee, cost, and budget.

All sample data is in English. However, when installing the EMP / DEPT dataset, you can also choose Arabic, Chinese, Czech, French, German, Italian, Japanese, Korean, Polish, Russian, or Spanish. Wherever possible, the examples in this guide use the simple EMP and DEPT tables from the Employees and Departments sample dataset.

For more information, see Using Sample Datasets in Oracle APEX SQL Workshop Guide.