4.4 Using Sample Datasets

Use Sample datasets to build sample applications.

Parent topic: Using Oracle Application Express Utilities

4.4.1 About Sample Datasets

Sample datasets enable you to easily build sample applications. Each dataset includes sufficient data to build pages with various different components.

Install, refresh, or replace sample datasets within one of the schemas associated with your workspace. The database objects can also be easily removed.Each dataset includes various database objects and sample data. The sample data is available in one or more languages.

Note:

Only a single language can be loaded into the sample database objects. If you select a different language, the currently loaded data is replaced.

Parent topic: Using Sample Datasets

4.4.2 Accessing Sample Datasets

Access the Sample Dataset page by clicking Utilities and then Sample Datasets.

To access the Sample Datasets page:

  1. On the Workspace home page, click the SQL Workshop icon.
  2. Click Utilities.
  3. Click Sample Datasets.

    The Sample Datasets page appears with a list of datasets.

Parent topic: Using Sample Datasets

4.4.3 Installing a Sample Dataset

You can install sample dataset to your workspace.

To install the Sample Datasets:

  1. On the Workspace home page, click the SQL Workshop icon.
  2. Click Utilities.
  3. Click Sample Datasets.

    The Sample Datasets page appears with a list of datasets.

  4. Select the sample dataset and click Install under Action.

    The Manage Sample Dataset page appears.

  5. Click Next.

    The Load Sample Dataset page appears with details of database objects.

  6. Click Install Dataset.

    The Load Sample Dataset - Result page appears with the list of installed database objects.

  7. On Load Sample Dataset

    • Click Exit to exit the wizard.

    • Click Create Application to create a new application based on this database.

Parent topic: Using Sample Datasets

4.4.4 Removing a Sample Dataset

You can remove the installed dataset.

To remove installed dataset:

  1. On the Workspace home page, click the SQL Workshop icon.
  2. Click Utilities.
  3. Click Sample Datasets.

    The Sample Datasets page appears with a list of datasets. Installed Datasets displays details of Schema and Date Installed.

  4. Click Update under Action.

    The Manage Sample Dataset page appears.

  5. Click Remove Dataset.

Parent topic: Using Sample Datasets

4.4.5 Refreshing a Sample Dataset

You can refresh the installed dataset.

To install the Sample Datasets:

  1. On the Workspace home page, click the SQL Workshop icon.
  2. Click Utilities.
  3. Click Sample Datasets.

    The Sample Datasets page appears with a list of datasets. Installed Datasets displays details of Schema and Date Installed.

  4. Click Update under Action.

    The Manage Sample Dataset page appears.

  5. Click Next.
  6. Select Refresh Existing Dataset.

Parent topic: Using Sample Datasets

4.4.6 Changing the Schema for a Sample Dataset

You can change the schema for a installed dataset.

To change the schema for a Sample Datasets:

  1. On the Workspace home page, click the SQL Workshop icon.
  2. Click Utilities.
  3. Click Sample Datasets.

    The Sample Datasets page appears with a list of datasets. Installed Datasets displays details of Schema and Date Installed.

  4. Click Update under Action.

    The Manage Sample Dataset page appears.

  5. Select Schema.

    Note:

    This option is displayed if you have more than one schema associated with your workspace.

  6. Click Next.

Parent topic: Using Sample Datasets