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
| 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}}