Creating Advanced Application Features with Oracle Application Express 18

Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps with world-class features that can be deployed anywhere. This Learning Path guides you on how to add advanced features such as Oracle REST Data Services (ORDS) service, Data Load Wizard and email templates to your app. You will also learn to translate an application's user interface.

Beginner

145 Min

6 Modules

Before You Begin
0 Min

Show
To complete these tutorials you need:

Access to Oracle Application Express release 18

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 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

Click the APEX browser bookmark.

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 these tutorials. Your Application ID is assigned automatically when you create the application.
Creating a REST enabled SQL Reference
40 Min
In this module, you learn to execute SQL query or PL/SQL defined at the component level on a remote database using REST Enabled SQL References.

Show
You need a specifically configured environment to be able to perform the tutorials in this module. We have configured this environment in a Virtual Machine named Database App Development. The tutorials are also uploaded in this VM. To download this VM, follow the instructions on this site: https://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-hols-2578401.html
Working with Web Source Modules
25 Min
In this module, you will learn to create a web source module and consume it in your app.

Show
Oracle Application Express 18: Web Source Module (1 of 2) - Creating 15 Min

Oracle Application Express 18: Web Source Module (2 of 2) - Consuming 10 Min
Working with Data Load Wizard
10 Min
In this module, you learn to create an app and add a Data Load wizard feature to the app. You also test the Data Load wizard.

Show
Oracle Application Express 18: Creating a Data Load Wizard for Your Application 10 Min
Integrating Email Templates into an Application
30 Min
In this module, you will create an email template for an existing application that sends out email notifications.

Show
Oracle Application Express 18: Email Templates (1 of 2) - Configure the Template 15 Min

Oracle Application Express 18: Email Templates (2 of 2) - Call the Template 15 Min
Translating an Application
40 Min
In this module, you learn to translate the UI of your app into another natural language.

Show
Oracle Application Express 18: App Translation (1 of 2) - Translating Imported App 20 Min

Oracle Application Express 18: App Translation (2 of 2) - Specifying Primary language and Translating Messages 20 Min

Alert Message

Breadcrumb for learning path

Main Parent

Learning Path Details Parent

Information

Creating Advanced Application Features with Oracle Application Express 18

Enroll the User-Public

Learning_path_filler

Learning_path_icons

Learning Path Contents

Module Sections Topics and more