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