Previous Next JavaScript must be enabled to correctly display this content

## SHOW REGIONS Statement

Syntax

    show_regions_statement ::= SHOW [AS JSON] REGIONS

Semantics

The show regions statement provides the list of regions present in the Multi-Region Oracle NoSQL Database.

AS JSON can be specified if you want the output to be in JSON format.

Example 4-2 Show Regions

The following statement lists all the existing regions.

    SHOW REGIONS

Output:

    regions
      my_region1 (remote, active)
      my_region2 (remote, active)

Example 4-3 Show Regions

The following statement lists all the existing regions in JSON format.

    SHOW AS JSON REGIONS

Output:

    {"regions" : [
        {"name" : "my_region1", "type" : "remote", "state" : "active"},
        {"name" : "my_region2", "type" : "remote", "state" : "active"}
    ]}