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:

Successful response

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, locationsIdpageSize, pageToken, filterLists 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 pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';