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