Install Oracle Database 23c (23.3), Oracle APEX, ORDS, JSON-Relational Duality Views

Описание: In this How to series video tutorial, we will see the following:

0:08 Login to Oracle Cloud and Create a Compute Instance
1:09 SSH into the Compute Instance and yum update
6:19 Download and Install Oracle Database 23c (23.3).
8:03 Configure Database 23c
10:01 Set bash_profile
12:54 Sqlplus Connect
14:14 Download and Install the latest version of Oracle APEX.
22:19 Download and Install Oracle JDK
23:02 Install Oracle REST Data Service [ORDS].
23:59 Configure ORDS.
27:15 Setup Virtual Cloud Network Security List and Linux Firewall
30:17 Access ORDS and Oracle APEX application
31:46 Create Database User.
34:18 Import Sample schema using SQL*Loader - sqlldr.
35:15 Import Graph Sample Data
39:24 Create Oracle APEX workspace
42:45 Install Sample APEX Graph Application
43:48 Create Sample Bank Application with pre-loaded data.
49:23 Access tables through Oracle REST Data Service [ORDS]
52:18 Working with JSON Relational Duality Views of Oracle Database 23c.
52:19 Create Master Detail Oracle APEX Application
01:06:40 Using Auto REST expose few tables for REST API access.
01:08:23 Update Master Detail data from APEX Application and view it in REST Client
01:09:58 Thank you and links to Articles

Article Links:
https://bit.ly/json-duality
https://bit.ly/db23c-new-features