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. REST APIs (HTTPS) for your Oracle Database
  2. SQL Developer Web
  3. Oracle Database management REST APIs
  4. PL/SQL Gateway, a replacement for mod_plsql
  5. SODA for REST, REST APIs for managing your JSON Document Store

Most of my content here is concentrated into categories 1-3.

What is ORDS?

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

ORDS will route your request to the appropriate database, and call the appropriate query or PL/SQL anonymous block), and return the output and HTTP codes.

For most calls, that’s going to be the results of a SQL statement – paginated and formatted as JSON.

What that looks like –

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

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

General Info

Examples

Database Actions (formerly SQLDev 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!