GET, POST, PUT, DELETE your way in and out of Oracle Database.
ORDS doesn’t require APEX, and you can run APEX without ORDS. My posts here concentrate on core ORDS features, generally REST enabling your Oracle Database.
ORDS is our middle tier JAVA application that allows you to access your Oracle Database resources via REST. In the tiniest and simplest of nutshells, GET|POST|PUT|DELETE|HEAD /db_stuff/ – ORDS maps a URI to something in your Oracle Database (a query, an object, an anonymous block, etc.), runs the appropriate SQL/PLSQL, and returns any output as JSON.
That kinda looks like this:
Manage ORDS from your terminal, via PL/SQL APIs, or our GUI in SQL Developer.
Here are some posts to help you get started with Oracle REST Data Services.
- Install and Configure ORDS from SQL Developer
- Creating an ORDS User
- Route Parameters OR Query Strings
- Auto REST Your Table – Insert Record(s) with POST
- Auto REST Your Table – Batch Load CSV with POST
- BLOBs and Media Types
- Parameters and :binds
ALL of my ORDS Posts (also good for RSS feeds)
We have 3 other great blog resources for you when it comes to ORDS:
- Official ORDS Blog on Oracle.com
- ORDS dev boss, developer, and all things Oracle tools extraordinaire, Kris Rice
- ORDS lead developer, Colm Divilly