Oracle Application Express APEX 20.1 Administration

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

Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.

Oracle Application Express (APEX) is one of the most exciting application development tools in the software development industry. APEX provides a true Rapid Application Development environment that can help you implement an idea right from concept to a working production level application in a short period of time

In this course You will learn to create oracle database and install apex and configure embedded pl/sql gateway and ORDS

Introduction

Installation of Windows 10 on Oracle Virtual Box

Installation of Oracle 19c and creation of database

Installation of Oracle APEX 20.1

Installation of Tomcat

Installation of ORDS

Oracle APEX ADMIN Tasks

A bonus lecture is also added for Oracle Linux 8 Installation on Oracle VM

You can choose any one of the three Web listeners - Oracle REST Data Services (ORDS), Oracle HTTP Server, and Embedded PL/SQL gateway.

Oracle Application Express uses a simple architecture where pages are dynamically generated using metadata stored within the Oracle Database. There is no code generation or file-based compilation. Once fully installed, a Uniform Resource Locator (URL) is defined for both developers and end users to access Oracle Application Express. Users require only a Web browser and the required URL. No additional client software is required.

The Web listener functions as a communications broker between the Web browser and the Oracle Application Express objects in the Oracle database by mapping browser requests into database stored procedure calls. You have a choice of three Web listeners.

• Oracle REST Data Services (formerly Oracle Application Express Listener) - ORDS

• Oracle HTTP Server.

• Embedded PL/SQL gateway.