Oracle REST Data Services (ORDS)

ORDS logo
GET, POST, PUT, DELETE your way in and out of Oracle Database.

This is my Resource page for Oracle REST Data Services (ORDS).

ORDS offers the following features:

  1. Web Services (HTTPS) for your Oracle Database
  2. SQL Developer Web
  3. Database management REST API
  4. PL/SQL Gateway, a replacement for mod_plsql

Most of my content here is found in categories 1-3. I will try to get more content on the PL/SQL Gateway as time allows…

What is ORDS?

ORDS is our middle tier JAVA application that allows you to access your Oracle Database resources via REST. Use standard HTTP calls (GET|POST|PUT|DELETE|HEAD) via URIs that ORDS makes available (/ords/database123/user3/module5/something/)

ORDS will find and run the appropriate database workload (a query, an anonymous block), and return the output as formatted JSON.

Or if you prefer pictures:

Manage ORDS from your terminal, with its PL/SQL API, or our GUI in SQL Developer.

Here are some posts to help you get started with Oracle REST Data Services.

General Info

Examples

SQL Developer Web

DBAPI – Managing your Oracle Instance

Can’t find what you’re looking for?

ALL of my ORDS Posts (also good for RSS feeds)

We have 3 other great blog resources for you when it comes to ORDS:

ORDS TV!