This 5 minute tutorial shows you how to install a sample
dataset in Oracle Application Express 18. This is the first
tutorial in the series Oracle Application Express 18: Create
Application Wizard. Read the tutorials in sequence:
Oracle Application Express includes four sample datasets.
Each dataset includes sufficient data to enable you to build
applications with pages containing different types of
components.
With a few clicks of the mouse you can install, refresh,
replace, or remove sample datasets within one of the schemas
associated with your workspace. In this tutorial, you install
the sample dataset, Project Data.
What Do You Need?
To complete this tutorial you need to:
Access to Oracle Application Express 18.1 or later
Install the sample dataset, Project Data in your
workspace.
Accessing your Development Environment
How you sign in and access Oracle Application Express depends
upon where Oracle Application Express resides. Oracle
Application Express may reside in a local on-premises Oracle
Database or in a hosted environment, such as the Oracle Cloud.
The sign in credentials you use to sign in differ depending upon
the installation type.
Free Workspace: Give Oracle Application Express a
test run by signing up for a free workspace. To request an
evaluation workspace, go to apex.oracle.com, and click Get
Started for Free.
Oracle Cloud: Develop and deploy applications without
worrying about infrastructure, repair, and downtime. Oracle
Application Express is available in Exadata Express Cloud
Service and Database Cloud Service. However, you need to
manually customize your databases to install and enable Oracle
Application Express. To learn more, see Oracle Database Cloud Service.
Oracle Application Express On-premises: Install
Oracle Application Express directly within any Oracle Database
and then sign in to your workspace using your sign in
credentials. For details on your sign in credentials, contact
your administrator or see Oracle Application Express Installation
Guide.
Oracle Application Express Pre-Built VM: Install a
Pre-Built Virtual Machine (VM) which includes an Oracle
Database and Oracle Application Express 18.1. To learn more,
see Hands-On Lab.
Once the VM is installed, start the VM:
Click the big red circle labeled Start.
Click the APEX shortcut, or enter the following URL:
http://localhost:8080/ords/f?p=4550:1.
When prompted to sign in, enter the sign in credentials
(unless given other credentials to use):
Workspace: obe
Username: obe
Password: oracle
Note your Application ID may be different when compared to the
screenshots in this tutorial. Your Application ID is assigned
automatically when you create the application.
Install
Sample Dataset
To install the sample dataset:
In the Oracle Application Express Workspace home page, click
SQL Workshop.
Select Utilities and click Sample Datasets.
On the Sample Datasets page, find the dataset Project
Data and click Install. If the sample dataset is
already installed, then click Update.
Click Install Dataset. The Load Sample Dataset -
Results page appears. At this point, you can create an
application or exit. Click Exit. The Sample Dataset
page displays again. Description
of the illustration project_data_update.pngNote: The Action column now displays Update
instead of Install. Tip: You can click Update to refresh a sample
dataset or remove it.
This completes the task of loading Project Data sample
dataset.
Oracle
Application Express 18: Create Application Wizard (1 of 2) - Installing
Sample Dataset
Before You Begin
Install
Sample Dataset
Next
Tutorial
Want
to Learn More?