db_versions
Creates, updates, deletes, gets or lists a db_versions resource.
Overview
| Name | db_versions |
| Type | Resource |
| Id | google.oracledatabase.db_versions |
Fields
The following fields are returned by SELECT queries:
- list
| Name | Datatype | Description |
|---|---|---|
name | string | Output only. The name of the DbVersion resource in the following format: projects/{project}/locations/{region}/dbVersions/{db_version} |
properties | object | Output only. The properties of the DbVersion. (id: DbVersionProperties) |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | projectsId, locationsId | pageSize, pageToken, filter | List 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.
| Name | Datatype | Description |
|---|---|---|
locationsId | string | |
projectsId | string | |
filter | string | |
pageSize | integer (int32) | |
pageToken | string |
SELECT examples
- list
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 }}'
;