autonomous_database_versions

Creates, updates, deletes, gets or lists an autonomous_database_versions resource.

Overview

Name	autonomous_database_versions
Type	Resource
Id	azure_isv.oracledatabase.autonomous_database_versions

Fields

The following fields are returned by SELECT queries:

get

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.
dbWorkload	string	The Autonomous Database workload type. Known values are: "OLTP", "DW", "AJD", and "APEX". (OLTP, DW, AJD, APEX)
isDefaultForFree	boolean	True if this version of the Oracle Database software's default is free.
isDefaultForPaid	boolean	True if this version of the Oracle Database software's default is paid.
isFreeTierEnabled	boolean	True if this version of the Oracle Database software can be used for Always-Free Autonomous Databases.
isPaidEnabled	boolean	True if this version of the Oracle Database software has payments enabled.
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	Supported Autonomous Db versions. Required.

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.
dbWorkload	string	The Autonomous Database workload type. Known values are: "OLTP", "DW", "AJD", and "APEX". (OLTP, DW, AJD, APEX)
isDefaultForFree	boolean	True if this version of the Oracle Database software's default is free.
isDefaultForPaid	boolean	True if this version of the Oracle Database software's default is paid.
isFreeTierEnabled	boolean	True if this version of the Oracle Database software can be used for Always-Free Autonomous Databases.
isPaidEnabled	boolean	True if this version of the Oracle Database software has payments enabled.
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	Supported Autonomous Db versions. Required.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	location, autonomousdbversionsname, subscription_id		Get a AutonomousDbVersion.
list_by_location	select	location, subscription_id		List AutonomousDbVersion 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
autonomousdbversionsname	string	AutonomousDbVersion name. Required.
location	string	The name of the Azure region. Required.
subscription_id	string

SELECT examples

get

Get a AutonomousDbVersion.

SELECT
id,
name,
dbWorkload,
isDefaultForFree,
isDefaultForPaid,
isFreeTierEnabled,
isPaidEnabled,
systemData,
type,
version
FROM azure_isv.oracledatabase.autonomous_database_versions
WHERE location = '{{ location }}' -- required
AND autonomousdbversionsname = '{{ autonomousdbversionsname }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_location

List AutonomousDbVersion resources by SubscriptionLocationResource.

SELECT
id,
name,
dbWorkload,
isDefaultForFree,
isDefaultForPaid,
isFreeTierEnabled,
isPaidEnabled,
systemData,
type,
version
FROM azure_isv.oracledatabase.autonomous_database_versions
WHERE location = '{{ location }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;