autonomous_db_versions

Creates, updates, deletes, gets or lists an autonomous_db_versions resource.

Overview

Name	autonomous_db_versions
Type	Resource
Id	google.oracledatabase.autonomous_db_versions

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Identifier. The name of the Autonomous Database Version resource with the format: projects/{project}/locations/{region}/autonomousDbVersions/{autonomous_db_version}
dbWorkload	string	Output only. The Autonomous Database workload type. (DB_WORKLOAD_UNSPECIFIED, OLTP, DW, AJD, APEX)
version	string	Output only. An Oracle Database version for Autonomous Database.
workloadUri	string	Output only. A URL that points to a detailed description of the Autonomous Database version.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	projectsId, locationsId	pageSize, pageToken	Lists all the available Autonomous Database versions for a 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.

Name	Datatype	Description
locationsId	string
projectsId	string
pageSize	integer (int32)
pageToken	string

SELECT examples

list

Lists all the available Autonomous Database versions for a project and location.

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