db_versions
Creates, updates, deletes, gets or lists a db_versions resource.
Overview
| Name | db_versions |
| Type | Resource |
| Id | azure_isv.oracledatabase.db_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. |
isLatestForMajorVersion | boolean | True if this version of the Oracle Database software is the latest version for a release. |
isPreviewDbVersion | boolean | True if this version of the Oracle Database software is the preview version. |
isUpgradeSupported | boolean | True if this version of the Oracle Database software is supported for Upgrade. |
supportsPdb | boolean | True if this version of the Oracle Database software supports pluggable databases. |
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 Database 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. |
isLatestForMajorVersion | boolean | True if this version of the Oracle Database software is the latest version for a release. |
isPreviewDbVersion | boolean | True if this version of the Oracle Database software is the preview version. |
isUpgradeSupported | boolean | True if this version of the Oracle Database software is supported for Upgrade. |
supportsPdb | boolean | True if this version of the Oracle Database software supports pluggable databases. |
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 Database version. Required. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | location, dbversionsname, subscription_id | Get a DbVersion. | |
list_by_location | select | location, subscription_id | dbSystemShape, dbSystemId, storageManagement, isUpgradeSupported, isDatabaseSoftwareImageSupported, shapeFamily | List DbVersion 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 |
|---|---|---|
dbversionsname | string | DbVersion name. Required. |
location | string | The name of the Azure region. Required. |
subscription_id | string | |
dbSystemId | string | The DB system AzureId. If provided, filters the results to the set of database versions which are supported for the DB system. Default value is None. |
dbSystemShape | string | If provided, filters the results to the set of database versions which are supported for the given shape. e.g., VM.Standard.E5.Flex. "VM.Standard.x86" Default value is None. |
isDatabaseSoftwareImageSupported | boolean | If true, filters the results to the set of Oracle Database versions that are supported for the database software images. Default value is None. |
isUpgradeSupported | boolean | If true, filters the results to the set of database versions which are supported for Upgrade. Default value is None. |
shapeFamily | string | If provided, filters the results to the set of database versions which are supported for the given shape family. Known values are: "EXADATA", "EXADB_XS", "SINGLENODE", and "VIRTUALMACHINE". Default value is None. |
storageManagement | string | The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM. "LVM" Default value is None. |
SELECT examples
- get
- list_by_location
Get a DbVersion.
SELECT
id,
name,
isLatestForMajorVersion,
isPreviewDbVersion,
isUpgradeSupported,
supportsPdb,
systemData,
type,
version
FROM azure_isv.oracledatabase.db_versions
WHERE location = '{{ location }}' -- required
AND dbversionsname = '{{ dbversionsname }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;
List DbVersion resources by SubscriptionLocationResource.
SELECT
id,
name,
isLatestForMajorVersion,
isPreviewDbVersion,
isUpgradeSupported,
supportsPdb,
systemData,
type,
version
FROM azure_isv.oracledatabase.db_versions
WHERE location = '{{ location }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND dbSystemShape = '{{ dbSystemShape }}'
AND dbSystemId = '{{ dbSystemId }}'
AND storageManagement = '{{ storageManagement }}'
AND isUpgradeSupported = '{{ isUpgradeSupported }}'
AND isDatabaseSoftwareImageSupported = '{{ isDatabaseSoftwareImageSupported }}'
AND shapeFamily = '{{ shapeFamily }}'
;