db_system_shapes
Creates, updates, deletes, gets or lists a db_system_shapes resource.
Overview
| Name | db_system_shapes |
| Type | Resource |
| Id | azure_isv.oracle.db_system_shapes |
Fields
The following fields are returned by SELECT queries:
- get
- list_by_location
Azure operation completed successfully.
| Name | Datatype | Description |
|---|---|---|
properties | object | The resource-specific properties for this resource. |
Azure operation completed successfully.
| Name | Datatype | Description |
|---|---|---|
properties | object | The resource-specific properties for this resource. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | subscriptionId, location, dbsystemshapename | Get a DbSystemShape | |
list_by_location | select | subscriptionId, location | List DbSystemShape resources by Location |
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 |
|---|---|---|
dbsystemshapename | string | DbSystemShape name |
location | string | The name of the Azure region. |
subscriptionId | string (uuid) | The ID of the target subscription. The value must be an UUID. |
SELECT examples
- get
- list_by_location
Get a DbSystemShape
SELECT
properties
FROM azure_isv.oracle.db_system_shapes
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND location = '{{ location }}' -- required
AND dbsystemshapename = '{{ dbsystemshapename }}' -- required
;
List DbSystemShape resources by Location
SELECT
properties
FROM azure_isv.oracle.db_system_shapes
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND location = '{{ location }}' -- required
;