Logo
OCI NoSQL Playground API Documentation

Prepare a SQL statement for use in a query with variable substitution.

GET {{baseUrl}}/query/prepare?compartmentId={{compartment_ocid}}&statement=SELECT * FROM DUAL

Prepare a SQL statement for use in a query with variable substitution.

 

Body PARAM

Key Datatype Required Description 
compartmentId
string (Required) The ID of a table's compartment.
statement
string (Required) A NoSQL SQL statement.



HEADERS

Key Datatype Required Description 
opc-request-id
string The client request ID for tracing.
Accept
string




RESPONSES

status OK

{ "statement": "aliqua exercitation", "usage": { "readUnitsConsumed": 65974166, "writeUnitsConsumed": -44702714 } }



Curl
curl -X GET 'https://nosql.region.oci.oraclecloud.com/20190828/query/prepare?compartmentId=compartment_ocid&statement=SELECT * FROM DUAL?compartmentId=compartment_ocid&statement=SELECT * FROM DUAL' -H 'opc-request-id: $randomUUID' -H 'Accept: application/json'

ENDPOINTS