> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.
# OCI Cloud Query
## Background[](#background "Direct link to Background")
The *Run Oracle Cloud Infrastructure Cloud Query* Action performs [Steampipe queries](https://hub.steampipe.io/plugins/turbot/oci) on Oracle-Cloud Infrastructure resources with a powerful and simple PostgreSQL syntax.
For example, listing all dbs in your Oracle Cloud database and their basic info can be don simply:
```
select db_name, id, lifecycle_state, time_createdfrom oci_database_db;
```
List all unavailable databases:
```
select db_name, id, lifecycle_state, time_createdfrom oci_database_dbwhere lifecycle_state <> 'AVAILABLE';
```
A query to list volumes created in the root compartment:
```
select id as volume_id, display_name, lifecycle_state, tenant_id, compartment_idfrom oci_core_volumewhere compartment_id = tenant_id;
```
A full description of all existing tables and official examples are provided here:
* [The Official OCI Plugin Documentation](https://hub.steampipe.io/plugins/turbot/oci/tables)
* [The Blink Automation Library](https://library.blinkops.com/workflows?vendors=Oracle%20Cloud\&level=basic)
Blink supports this Steampipe version: v0.17.2.
## Action Parameters[](#action-parameters "Direct link to Action Parameters")
| Parameter | Description |
| ------------- | ------------------------------------------------------------------------------------------- |
| SQL statement | The SQL query to execute against database resources. Use standard SQL syntax. |
| Output format | The representation of the output result. The possible options are "Table", "CSV" or "JSON". |
