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.

Request Params

KeyDatatypeRequiredDescription
compartmentIdstring(Required) The ID of a table's compartment.
statementstring(Required) A NoSQL SQL statement.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
Acceptstring

RESPONSES

status: OK

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