Introduction to ORDS Oracle REST Data Services (for PaaS)

Learn how to enable ORDS REST services for a schema, create a REST API for an employee table, and fetch, update, and delete data from browser using the OpenAPI catalog.

Use postman to test the ORDS API, copy the base URL from the Oracle REST interface, fetch all employee details in JSON, and filter by employee ID with q.

Consume Oracle Rest Data Services REST APIs in Oracle Visual Builder to fetch and display employee data from a database table.

Secure ORDS REST APIs for PaaS using OAuth 2.0 client credentials, map privileges to API paths, and obtain bearer tokens to access data safely from Visual Builder.

Learn to revoke and delete ORDS privileges, mappings, modules, and OAuth clients using SQL queries, and verify cleanup of roles, privileges, and client associations in your audience solutions.

Enable ords oracle rest data services api security with sql developer by auto creating roles and privileges, then use client credentials to obtain a token and access employee data securely.

Create a simple Oracle REST Data Services API to fetch all records from a database table using an HTTP GET request, returning the data in JSON.

Learn to build a REST API with Oracle REST Data Services by using a path parameter or bind variable in the URL to fetch employee details via a GET request.

Explore creating an ORDS rest API that accepts a JSON array in the request body, iterates items with PL/SQL, and inserts employees into a table.

Learn to build a rest api for an Oracle database table that accepts a JSON object in the request body to insert records via PL/SQL or direct SQL.

Create a simple ORDS API to fetch records from a table, using templates, collection queries, and pagination with limit and offset.

Learn to create a dds api with a path parameter in the uri, bind it to a SQL query, define and map parameters, and test with Postman.

Learn to create an ords API with header parameters using a v2 template, map header values to SQL bind parameters, and test with Postman for get and other methods.

Learn to create and bind query parameters for an ORDS rest API, using name and id, with uri source type, and test via postman to filter data.

Learn how to return SYSREFCURSOR data in a result set out parameter using ORDS, with PL/SQL blocks, and binding to query parameters and out header parameters.

Generate a json object payload in pl/sql using the json object data type for employees. Serialize to a clob and return via ords.

Create a scalable API by returning a JSON array directly as a clock from PL/SQL, avoiding the 4000-byte limit of JSON serialize for humongous data.

Create an ORDS api with custom pagination fields in the json response by generating a json object in pl sql, returning items, total count, limit, offset, and has more flag.

Expose existing PL/SQL procedures using a custom object table type via ORDS REST API. Transform incoming JSON to the matching type for bulk inserts into the employee table without rewriting.

Expose a legacy PL/SQL procedure with a custom table object type OUT parameter as JSON using ORDS REST API, mapping output to JSON array.

Update header and line tables in a single json payload using add, update, and delete operations. Explore a master-detail po header and lines flow with ords oracle rest data services.

Learn to build an ords rest data services api that returns a master–detail purchase order as a json payload by joining header and line tables with a plsql method.

Explore how ORDS on PaaS handles humongous JSON payloads via CLOB input in a POST request, parsing with apex_json and inserting into the employee table.

Expose a PL/SQL procedure as a REST API with ords to return humongous data as a JSON array via blob output, covering up to 70,000 employee records.

Celebrate completing the course by practicing the classes, share feedback via q&a or messages, rate the course, and email beenham dot apps at gmail.com to help improve the content.