18.1 Working with Sample Data

Learn about accessing sample data available in Oracle APEX.

• Accessing Read-only Sample Data When Creating or Editing a Page
  Access read-only sample data set from the Create Page Wizard and Page Designer.
• About Installing Sample Data from SQL Workshop
  Install editable sample data sets in SQL Workshop, Utilities.

18.1.1 Accessing Read-only Sample Data When Creating or Editing a Page

Access read-only sample data set from the Create Page Wizard and Page Designer.

Oracle APEX includes the following sample data sets: Employees, Geolocation, and Time-Based data. Note that these sample data sets are read-only and available from both the Create Page Wizard and from Page Designer.

Tip:

You can create most page components on top of these sample data sets (including forms and editable interactive grids). However, since these data sets are read-only, Insert, Update, or Delete operations result in an error message.

To select a sample data set in the Create Page Wizard:

1. On the Workspace home page, click App Builder.
2. Select an application.
   The Application home page appears.
3. Click the Create Page button.

   The Create Page Wizard appears.

4. Select a page Component.
5. If a built-in sample data set is available and suitable for the component, the Data Source displays Sample Data.
6. Continue configuring your component and click Create Page.

To select a sample data set for a component in Page Designer:

7. In the Rending tab (left pane), select the component.
8. In the Property Editor (right pane), edit the following:
   1. Find Source.
   2. Source, Location - Select Sample Data.
9. Continue configuring your component.
10. Click the Save and Run Page.

18.1.2 About Installing Sample Data from SQL Workshop

Install editable sample data sets in SQL Workshop, Utilities.

Navigate to SQL Workshop, Utilities, Sample Datasets to install editable sample data sets with sufficient data to build sample applications containing a variety of different components. Each data set includes various database objects and sample data and is available in one or more languages. SQL Workshop provides a simple user interface which enables you to install, refresh or remove the underlying database objects. To learn more, see About Sample Datasets in Oracle APEX SQL Workshop Guide.