system_versions
Creates, updates, deletes, gets or lists a system_versions resource.
Overview
| Name | system_versions |
| Type | Resource |
| Id | azure_isv.oracledatabase.system_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. |
systemVersion | string | A valid Oracle System Version. Required. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
| 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. |
systemVersion | string | A valid Oracle System Version. Required. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | location, systemversionname, subscription_id | Get a SystemVersion. | |
list_by_location | select | location, subscription_id | List SystemVersion 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 |
|---|---|---|
location | string | The name of the Azure region. Required. |
subscription_id | string | |
systemversionname | string | SystemVersion name. Required. |
SELECT examples
- get
- list_by_location
Get a SystemVersion.
SELECT
id,
name,
systemData,
systemVersion,
type
FROM azure_isv.oracledatabase.system_versions
WHERE location = '{{ location }}' -- required
AND systemversionname = '{{ systemversionname }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;
List SystemVersion resources by SubscriptionLocationResource.
SELECT
id,
name,
systemData,
systemVersion,
type
FROM azure_isv.oracledatabase.system_versions
WHERE location = '{{ location }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;