Scribd
Upload
22 views1 page

Aetut 13

This document outlines the steps to populate an Oracle Application Express workspace with sample tables and data from a provided .zip file. It includes instructions for downloading, extracting, and importing the data using SQL Workshop. The sample data resembles typical HR application datasets, including information on employees, projects, and schedules.

Uploaded by

Prashant Prajapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views1 page

Aetut 13

This document outlines the steps to populate an Oracle Application Express workspace with sample tables and data from a provided .zip file. It includes instructions for downloading, extracting, and importing the data using SQL Workshop. The sample data resembles typical HR application datasets, including information on employees, projects, and schedules.

Uploaded by

Prashant Prajapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

3

Populating Your Workspace

To build an Oracle Application Express app, you need a complete set of tables and
data. Oracle provides these in a .zip file that is designed to accompany this tutorial.

About This Lesson


In this lesson, you obtain and extract the .zip file to your local machine and use the
tools in Oracle Application Express (SQL Workshop and SQL Scripts) to import some
of its contents into your workspace.
Once imported, 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 Oracle Application Express HR apps use every day. They include
information typical of data sets for employees, projects, calendars, and schedules.

3.1 Setting Up Your Workspace


To proceed with this tutorial, you must meet complete the following tasks:

• Ensure you meet all the requirements that are described in "Before You Begin
(page 2-1)."

• Download the .zip file containing the latest tables and data.

To download the .zip file:

1. Navigate to the Tutorials page: http://docs.oracle.com/database/apex-5.1/nav/


tutorials.htm

2. Click Download sample tables and data zip file.

The download begins.

3. Extract the .zip file to an easily accessible location on your local machine.

3.2 Importing the Sample Tables


Oracle Application Express includes powerful wizards designed to quickly build an
initial app based on an existing set of data. However, first you must get the data into
your workspace. The .zip file that you downloaded earlier contains a script to generate
a set of sample tables.
Prepare your workspace by uploading the Demo_Project_Basic_Tables.sql
script to your workspace and run it in the SQL Workshop.

To import the sample tables into your workspace:

Populating Your Workspace 3-1

You might also like