This is my Resource page for Oracle REST Data Services (ORDS).
ORDS offers the following features:
- REST APIs (HTTPS) for your Oracle Database
- SQL Developer Web
- Oracle Database management REST APIs
- PL/SQL Gateway, a replacement for mod_plsql
- 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 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.
- How to debug your APIs
- 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
- Best Practices Guide for Database REST APIs
- Inserting a Row to a Table: the Definitive Example!
- Upload Files as Blobs (and download them again!)
- 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)
- Using a POST to run Queries
- 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
Your Favorite Content
These are the most popular posts over the past 18 months…
- THIS PAGE – you’re already here!
- How to Update the ORDS_PUBLIC_USER Password
- ORDS FAQ
- ORDS Architecture Deployment Overview
- Returning Raw JSON
- Query Filtering Examples
- How Paging Works
- Forward Responses
- Calling a PL/SQL Function
- 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
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!