gi_versions
Creates, updates, deletes, gets or lists a gi_versions resource.
Overview
| Name | gi_versions |
| Type | Resource |
| Id | azure_isv.oracledatabase.gi_versions |
Fields
The following fields are returned by SELECT queries:
- get
- list_by_location
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. |
name | string | The name of the resource. |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
version | string | A valid Oracle Grid Infrastructure (GI) software version. Required. |
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. |
name | string | The name of the resource. |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
version | string | A valid Oracle Grid Infrastructure (GI) software version. Required. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | location, giversionname, subscription_id | Get a GiVersion. | |
list_by_location | select | location, subscription_id | shape, zone, shapeAttribute | List GiVersion resources by SubscriptionLocationResource. |
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 |
|---|---|---|
giversionname | string | GiVersion name. Required. |
location | string | The name of the Azure region. Required. |
subscription_id | string | |
shape | string | If provided, filters the results for the given shape. Known values are: "Exadata.X9M", "Exadata.X11M", and "ExaDbXS". Default value is None. |
shapeAttribute | string | Filters the result for the given Shape Attribute, such as BLOCK_STORAGE or SMART_STORAGE. Default value is None. |
zone | string | Filters the result for the given Azure Availability Zone. Default value is None. |
SELECT examples
- get
- list_by_location
Get a GiVersion.
SELECT
id,
name,
systemData,
type,
version
FROM azure_isv.oracledatabase.gi_versions
WHERE location = '{{ location }}' -- required
AND giversionname = '{{ giversionname }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;
List GiVersion resources by SubscriptionLocationResource.
SELECT
id,
name,
systemData,
type,
version
FROM azure_isv.oracledatabase.gi_versions
WHERE location = '{{ location }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND shape = '{{ shape }}'
AND zone = '{{ zone }}'
AND shapeAttribute = '{{ shapeAttribute }}'
;