Oracle REST Data Services (ORDS)

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 –

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

General Info

• Frequently Asked Questions (FAQ)
• ORDS 101: HTTP, JSON, & REST, & how ORDS ties it all for Oracle – slides & video 
• RESTful Services and AUTOREST Examples – slides and video
• Install and Configure from SQL Developer
• AUTOREST – Low Code solution for REST access to your data and PL/SQL
• Developing a RESTful Service with SQL Developer Desktop’s IDE (Video)
• Developing a RESTful Service with SQL Developer Web
• Architecture Overview

Examples

• Upload Files as Blobs (and download them again!)
• Parameters
• Generate your own JSON
• Including Links in your REST API responses
• Paging your SQL Query Results
• PL/SQL (4 options for working with PL/SQL in your REST APIs)
• Query Filtering (Adding Query Filters to your REST APIs, no code required!)

Database Actions (formerly SQLDev Web)

• In Oracle Cloud Autonomous Database
• On Premises
• Loading Data
• Performance Hub
• Relational Diagrams (data modeler)
• Security & OAuth2
• REST Development
• JSON (SODA) Document Management

DBAPI – Managing your Oracle Instance

• Introduction
• Slides
• Data Pump Exports
• Data Pump Imports
• PDB Lifecycle Management

Your Favorite Content

These are the most popular posts over the past 18 months…

1. THIS PAGE – you’re already here!
2. How to Update the ORDS_PUBLIC_USER Password
3. ORDS FAQ
4. ORDS Architecture Deployment Overview
5. Returning Raw JSON
6. Query Filtering Examples
7. How Paging Works
8. Forward Responses
9. Calling a PL/SQL Function
10. The Easy Way to Protect All Services in a Schema

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:

• GitHub Examples
• ORDS dev boss, developer, and all things Oracle tools extraordinaire, Kris Rice
• ORDS lead developer, Colm Divilly

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!