In modern application development, exposing database logic as REST APIs is a powerful way to integrate systems. Oracle REST Data Services (ORDS) makes it easy to turn PL/SQL into RESTful APIs without needing a separate backend service.

In this blog, we’ll walk through how to create a simple POST API using ORDS and PL/SQL to insert data into a table.

Pre-requisites

A cloud-based ATP wallet (I prefer)

Let's start how we create the APIs on the top of any custom table which relies on databases