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!

See Episode 7 if you’re looking for a tutorial on installing ORDS. I do it from the command line using the interactive prompts, take you through the resulting config files, and then show you how to get started with SQL Developer Web – which now has interfaces for building the RESTful Web Services. So yeah, you can use ORDS to build ORDS based REST APIs!