RESTful Services in Oracle APEX - The Complete Guide (2026)

Name: RESTful Services in Oracle APEX - The Complete Guide (2026)
Rating: 4.2 (803 reviews)

Build a RESTful Service using ORDS (Oracle REST Data Services) in Oracle APEX. Unfold the power of REST Enabled SQL.

Created byVelchandru M

Last updated 7/2026

English

What you'll learn

Hosting Oracle APEX in Oracle Cloud
Build a RESTful Service with Oracle APEX
Learn in detail about ORDS
Understand the API programming in Oracle APEX
Learn about protecting the web services
Understand OAUTH to access the protected web services
Learn about implementing REST Enabled SQL Service
Learn how to consume the external API in Oracle APEX

Course content

8 sections • 26 lectures • 1h 42m total length

Introduction2:46
In this lecture, you will getting to know a brief overview of this course.
Prerequisites1:06
In this lecture, you will be informed with prerequisites before proceeding to further lectures in this course.
Learning Oracle APEX Fundamentals0:19

Setting up the Oracle Cloud and Oracle APEX3:15
In this lecture, we will be setting up the Oracle Cloud and creating an autonomous database where we will be using the Oracle APEX application.
Installing Sample Dataset(s)2:50
In this lecture, we will be installing the sample dataset(s) in our Oracle APEX application.
Enabling RESTful Access and Testing the Sample Service1:52
In this lecture, we will be navigating to RESTful Services in Oracle APEX and will start with enabling the RESTful Access and Testing it in Web Browser.
Using Postman (REST Client)2:56
In this lecture, we will be installing and usng Postman which has a better advantage over Web Browser to act as REST Client.

ORDS PL/SQL Package Reference0:15
Defining Module(s)4:53
In this lecture, we will define the module(s) in ORDS.
Defining Template(s)3:06
In this lecture, we will define the template(s) in ORDS.
Defining Handler(s)5:56
In this lecture, we will define the handler(s) in ORDS.
Defining Parameter(s)9:09
In this lecture, we will define the parameter(s) in ORDS.
More Examples5:42
In this lecture, we will explore more handlers and parameters definition in ORDS.

What is REST Enabled SQL Service?1:23
In this lecture, you will learn about the definition and the advantages of REST Enabled SQL Service
Consuming the service in another database6:15
In this lecture, we will be creating a REST Enabled SQL Service in Oracle APEX and we will try to consume it in another database.
Additional Features3:34
In this lecture, we will try to cover more additional features of REST Enabled SQL Service.
Testing the service in CURL and Postman6:27
In this lecture, we will try to test our REST Enabled SQL Service using the tools such as CURL Command and Postman Application.

Requirements

A standard web browser like Google Chrome / Mozilla Firefox / Opera / Edge / Safari
Postman Application (Web / Native)
Basic knowledge of Oracle APEX
Fundamentals of writing SQL and PL/SQL
REST Architecture concepts and terminology
You don't need to be a Oracle APEX or SQL or PL/SQL expert to succeed in this course!

Description

This is a very practical video course about how to build a RESTful Service in Oracle APEX.

Though this course is at an intermediate level, it explains the basics of a RESTful Service starting from ORDS (Oracle REST Data Service) in detail.

You will learn about setting up the Autonomous Database in Oracle Cloud and also how to use Postman which acts as the REST Client.

You will get to know how to enable the ORDS schema for RESTful Access in Oracle APEX.

Using the ORDS principles, you will learn how to build a RESTful Service from scratch.

Once a RESTful Service is created, you will understand how to protect it using the ORDS concepts, which block free access.

Following that, you will be clear on how to access the protected web services using OAUTH which is a recommended method nowadays.

You will learn about the REST Enabled SQL Service and how to implement it in Oracle APEX by consuming the service in another database.

You will get to know the advantages of using REST-enabled SQL Service over the standard RESTful Service.

Finally, you will get a brief idea about the REST Data Sources in Oracle APEX and the Legacy Apex Web Service PL/SQL API as well.

Who this course is for:

Developers looking to understand the backend programming of Oracle APEX

RESTful Services in Oracle APEX - The Complete Guide (2026)

What you'll learn

Explore related topics

Course content

Getting Started3 lectures • 4min

Setting up the Environment4 lectures • 11min

Understanding ORDS2 lectures • 6min

RESTful Services6 lectures • 29min

Protecting the Web Services4 lectures • 17min

REST Enabled SQL4 lectures • 18min

Additional Topics2 lectures • 17min

Next Steps1 lecture • 2min

Requirements

Description

Who this course is for: