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;
 
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;
 
{"regions" : [
    {"name" : "my_region1", "type" : "remote", "state" : "active"},
    {"name" : "my_region2", "type" : "remote", "state" : "active"}
]}