1. SQL Reference Guide
  2. Introduction to the SQL for Oracle NoSQL Database Shell
  3. Shell Utility Commands
  4. show regions

show regions

show_regions_statement ::= SHOW [AS JSON] REGIONS

The show regions statement provides the list of regions present in a multi-region Oracle NoSQL Database setup. The parameter AS JSON is optional and can be specified if you want the output to be in JSON format.

Example 1: Fetching all regions in a multi-region database setup
SHOW REGIONS;
 regions
    my_region1 (remote, active)
    my_region2 (remote, active)
Example 2: Fetching all regions in a multi-region database setup in JSON format
SHOW AS JSON REGIONS;
{"regions" : [
    {"name" : "my_region1", "type" : "remote", "state" : "active"},
    {"name" : "my_region2", "type" : "remote", "state" : "active"}
]}