Response Format and REST-Enabled SQL service in ORDS
Hello fellas!! 👋 Today’s topic: Understanding the REST-Enabled SQL Service in ORDS and How to Customize its Response Format. Rest-Enabled SQL service in ORDS: The REST-Enabled SQL service is a HTTPS web service that provides access to the Oracle Database SQL engine. You can POST SQL statements to the service. The service then runs the SQL statements against Oracle Database and returns the result to the client in a JSON format. Example: When making a request to the REST ENABLED SQL SERVICE, you typically by default get a response as the following: curl --location 'http://localhost:8086/ords//<schema_alias>/_/sql' \ --header 'Content-Type: application/json' \ -u "user:dummySecret" \ --data '{ "statementText": "select sysdate from dual" }' This is typically how the response would look like: { "env": { "defaultTimeZone": "UTC" }, "items": [ ...