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