3 Populating Your Workspace

To build an Oracle Application Express app, you need a complete set of tables and data.

About This Lesson

In this lesson, you install Sample Datasets provided by Oracle.

Once installed, you also review the output of the scripts in Object Browser to confirm the presence of the tables and data.

The sample tables and data that you load in these steps resemble the kind of information that real Application Express project management apps use every day. They include information typical of data sets for employees, projects, and calendars.

3.1 Installing the Sample Datasets

The Application Express SQL Workshop comes with several sample datasets intended to enhance app experimentation.

To install the Project Data sample dataset in SQL Workshop:

1. Sign in to your Oracle Application Express workspace.
2. Click SQL Workshop, click Utilities, and click Sample Datasets.

   Tip:

   You can also click the down arrow icons to open the drop-down menus on the tabs at the top of the screen to shortcut your way around your workspace.

   
   

   
   Description of the illustration workspace_sql_util_sample_datasets.png

   
   
3. Find Project Data in the list and click the adjacent Install button.
   
   

   
   Description of the illustration sql_util_sample_datasets_install.png

   
   
   The Manage Sample Dataset dialog displays.
4. Click Next.
5. Click Install Dataset.
6. In Results dialog, review the new objects.
   
   

   
   Description of the illustration sample_dataset_objects.png

   
   

   The script created the following objects:

   • SAMPLE$PROJECT_STATUS (Table)

   • SAMPLE$PROJECTS (Table)

   • SAMPLE$PROJECT_MILESTONES (Table)

   • SAMPLE$PROJECT_TASKS (Table)

   • SAMPLE$PROJECT_TASK_TODOS (Table)

   • SAMPLE$PROJECT_TASK_LINKS (Table)

   • SAMPLE$PROJECT_COMMENTS (Table)

   • SAMPLE$PROJECTS_V (View)

   • SAMPLE$PROJECTS_COMPLETED_V (View)

7. Click Exit.

   Note:

   The Create Application button is a shortcut to the Create Application Wizard loaded with the sample data.

You have populated the sample tables and data in your workspace.

3.2 Reviewing the Created Tables with Object Browser

Object Browser displays all the raw data present in the Oracle database schema associated with your workspace.

To navigate to Object Browser:

1. Click SQL Workshop to return to the SQL Workshop home page.
2. Click Object Browser.

   Tip:

   For quicker navigation, click the arrow next to SQL Workshop to display a drop-down menu.
3. In the list of tables, select SAMPLE$PROJECTS.
   
   

   
   Description of the illustration object_browser.png

   
   
4. Click the Data tab. The Data tab displays the raw information of the SAMPLE$PROJECTS table.
   
   

   
   Description of the illustration object_browser_sampleprojects.png

   
   

   Note:

   You can edit the data directly by clicking the Edit icon on the Data report. However, leave the data unchanged for now.
5. When finished, click the Oracle logo in the top-left of the page to return to the Workspace home page.

You have fully populated your workspace and are ready to create a new application.

Proceed to the next lesson.