Skip to main content

gi_versions

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

Overview​

Namegi_versions
TypeResource
Idgoogle.oracledatabase.gi_versions

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringIdentifier. The name of the Oracle Grid Infrastructure (GI) version resource with the format: projects/{project}/locations/{region}/giVersions/{gi_versions}
versionstringOptional. version

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsIdfilter, pageSize, pageTokenLists all the valid Oracle Grid Infrastructure (GI) versions for the given project and location.

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
locationsIdstring
projectsIdstring
filterstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples​

Lists all the valid Oracle Grid Infrastructure (GI) versions for the given project and location.

SELECT
name,
version
FROM google.oracledatabase.gi_versions
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;