RESTful Services in Oracle APEX The Complete Guide 2023

Build a RESTful Service using ORDS (Oracle REST Data Services) in Oracle APEX. Unfold the power of REST Enabled SQL.
RESTful Services in Oracle APEX The Complete Guide 2023
File Size :
660.92 MB
Total length :
1h 42m



Velchandru M


Last update




RESTful Services in Oracle APEX The Complete Guide 2023

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

RESTful Services in Oracle APEX The Complete Guide 2023


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!


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.


Section 1: Getting Started

Lecture 1 Introduction

Lecture 2 Prerequisites

Lecture 3 Learning Oracle APEX Fundamentals

Section 2: Setting up the Environment

Lecture 4 Setting up the Oracle Cloud and Oracle APEX

Lecture 5 Installing Sample Dataset(s)

Lecture 6 Enabling RESTful Access and Testing the Sample Service

Lecture 7 Using Postman (REST Client)

Section 3: Understanding ORDS

Lecture 8 What is ORDS?

Lecture 9 ORDS in Detail

Section 4: RESTful Services

Lecture 10 ORDS PL/SQL Package Reference

Lecture 11 Defining Module(s)

Lecture 12 Defining Template(s)

Lecture 13 Defining Handler(s)

Lecture 14 Defining Parameter(s)

Lecture 15 More Examples

Section 5: Protecting the Web Services

Lecture 16 OAUTH 2.0

Lecture 17 OAUTH PL/SQL Package Reference

Lecture 18 Defining Role(s) and Privilege(s)

Lecture 19 Accessing the Protected Web Services

Section 6: REST Enabled SQL

Lecture 20 What is REST Enabled SQL Service?

Lecture 21 Consuming the service in another database

Lecture 22 Additional Features

Lecture 23 Testing the service in CURL and Postman

Section 7: Additional Topics

Lecture 24 REST Data Sources

Lecture 25 Apex Web Service using PL/SQL

Section 8: Next Steps

Lecture 26 Congratulations!!

Developers looking to understand the backend programming of Oracle APEX

Course Information:

Udemy | English | 1h 42m | 660.92 MB
Created by: Velchandru M

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top