Reviewing REST API Basics

Review the HTTP, JSON, SQL, and PL/SQL basics behind REST APIs.

Before learning how to expose a REST API for your application, it’s good to review the basic “ingredients” involved in the recipe:

• Key HTTP methods that REST APIs use,

• The basic syntax of JSON documents,

• SQL features to construct JSON from relational data, and

• PL/SQL’s native JSON types, and

• Simplifications JSON Relational Duality Views enable in Oracle 26ai.