Understanding auto-rest (ORDS on steroids)

By Richard Martens

Elevator Pitch

The Oracle Restful Data Services allow to “rest-enable” database objects. This includes data-retrieval and data-manipulation. Using simple directives in the URL you can use all CRUD and Select functionality.

Description

The Oracle Restful Data Services allow to “rest-enable” database objects like Tables, Views, Procedures and Functions. This includes data-retrieval and data-manipulation.

Using a few simple directives in the URL you can search for specific records, order the result set or even limit the amount of records retrieved. On top of that the ORDS will automatically show you the resulting JSON

The session focuses on the creation and use of autorest enabled services on objects. The creation section (1st half) focuses on the right format of your JSON result. The seconds half covers consuming these services; how to do CRUD operations, how to search the for data, how to paginate etc.