db_nodes
Creates, updates, deletes, gets or lists a db_nodes resource.
Overview
| Name | db_nodes |
| Type | Resource |
| Id | google.oracledatabase.db_nodes |
Fields
The following fields are returned by SELECT queries:
- list
| Name | Datatype | Description |
|---|---|---|
name | string | Identifier. The name of the database node resource in the following format: projects/{project}/locations/{location}/cloudVmClusters/{cloud_vm_cluster}/dbNodes/{db_node} |
properties | object | Optional. Various properties of the database node. (id: DbNodeProperties) |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | projectsId, locationsId, cloudVmClustersId | pageSize, pageToken | Lists the database nodes of a VM Cluster. |
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 |
|---|---|---|
cloudVmClustersId | string | |
locationsId | string | |
projectsId | string | |
pageSize | integer (int32) | |
pageToken | string |
SELECT examples
- list
Lists the database nodes of a VM Cluster.
SELECT
name,
properties
FROM google.oracledatabase.db_nodes
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND cloudVmClustersId = '{{ cloudVmClustersId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;