REST APIs

Oracle REST Data Services also provides REST APIs that can be invoked via cURL to connect to an Oracle database and perform operations.

Users must be assigned to the "REST Enabled SQL" application role in order to use REST APIs with Oracle Utilities cloud services. See Pre-Defined Application Roles in the Oracle Utilities Cloud Services Administration Guide for more information about application roles used with Oracle Utilities cloud services.

The following is an example syntax for cURL command.

curl -i -X POST --user <username>:<password> --data-binary "<SQL statement>" -H "Content-Type: application/sql" -k <Oracle REST URL>

Contact your system administrator for Oracle SQL Developer Web and REST service URLs.

No additional configuration is required to use Oracle SQL Developer Web or REST services.