vw_autonomous_database_versions

Creates, updates, deletes, gets or lists a vw_autonomous_database_versions resource.

Overview

Name	vw_autonomous_database_versions
Type	View
Id	azure_isv.oracle.vw_autonomous_database_versions

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.dbWorkload') as "db_workload",
JSON_EXTRACT(properties, '$.isDefaultForFree') as "is_default_for_free",
JSON_EXTRACT(properties, '$.isDefaultForPaid') as "is_default_for_paid",
JSON_EXTRACT(properties, '$.isFreeTierEnabled') as "is_free_tier_enabled",
JSON_EXTRACT(properties, '$.isPaidEnabled') as "is_paid_enabled",
subscriptionId,
location,
autonomousdbversionsname
FROM azure_isv.oracle.autonomous_database_versions
WHERE subscriptionId = 'replace-me' AND location = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.version') as "version",
json_extract_path_text(properties, '$.dbWorkload') as "db_workload",
json_extract_path_text(properties, '$.isDefaultForFree') as "is_default_for_free",
json_extract_path_text(properties, '$.isDefaultForPaid') as "is_default_for_paid",
json_extract_path_text(properties, '$.isFreeTierEnabled') as "is_free_tier_enabled",
json_extract_path_text(properties, '$.isPaidEnabled') as "is_paid_enabled",
subscriptionId,
location,
autonomousdbversionsname
FROM azure_isv.oracle.autonomous_database_versions
WHERE subscriptionId = 'replace-me' AND location = 'replace-me';