Skip to main content

regions

Creates, updates, deletes, gets or lists a regions resource.

Overview​

Nameregions
TypeResource
Idoci.identity.regions

Fields​

The following fields are returned by SELECT queries:

A localized geographic area, such as Phoenix, AZ. Oracle Cloud Infrastructure is hosted in regions and Availability<br />Domains. A region is composed of several Availability Domains. An Availability Domain is one or more data centers<br />located within a region. For more information, see [Regions and Availability Domains](/Content/General/Concepts/regions.htm).<br /><br />To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized,<br />talk to an administrator. If you're an administrator who needs to write policies to give users access,<br />see [Get Started with Policies](/Content/Identity/policiesgs/get-started-with-policies.htm).<br />

NameDatatypeDescription
namestringThe name of the region. See [Regions and Availability Domains](/Content/General/Concepts/regions.htm) for the full list of supported region names. Example: us-phoenix-1
keystringThe key of the region. See [Regions and Availability Domains](/Content/General/Concepts/regions.htm) for the full list of supported 3-letter region codes. Example: PHX

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectregionLists all the regions offered by Oracle Cloud Infrastructure.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)

SELECT examples​

Lists all the regions offered by Oracle Cloud Infrastructure.

SELECT
name,
key
FROM oci.identity.regions
WHERE region = '{{ region }}' -- required
;