Skip to main content

db_versions

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

Overview​

Namedb_versions
TypeResource
Idgoogle.oracledatabase.db_versions

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringOutput only. The name of the DbVersion resource in the following format: projects/{project}/locations/{region}/dbVersions/{db_version}
propertiesobjectOutput only. The properties of the DbVersion. (id: DbVersionProperties)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsIdfilter, pageSize, pageTokenList DbVersions 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​

List DbVersions for the given project and location.

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