Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

Average carbon emission.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_average_carbon_emission_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sku_part_number varchar2(32767),
  average_carbon_emission number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_average_carbon_emission_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_average_carbon_emission_t (
    sku_part_number varchar2,
    average_carbon_emission number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Clean energy usage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_clean_energy_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_region varchar2(32767),
  ad varchar2(32767),
  usage number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_clean_energy_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_clean_energy_usage_t (
    l_region varchar2,
    ad varchar2,
    usage number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  l_values dbms_cloud_oci_usageapi_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_configuration_t (
    key varchar2,
    l_values dbms_cloud_oci_usageapi_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_configuration_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_configuration_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_configuration_t) NOT PERSISTABLE;

The available configurations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_configuration_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_usageapi_configuration_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_configuration_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_configuration_aggregation_t (
    items dbms_cloud_oci_usageapi_configuration_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The common fields for Cost Analysis UI rendering.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_cost_analysis_ui_t FORCE AUTHID CURRENT_USER IS OBJECT (
  graph varchar2(32767),
  is_cumulative_graph number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_cost_analysis_ui_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_cost_analysis_ui_t (
    graph varchar2,
    is_cumulative_graph number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The tag used for filtering.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace varchar2(32767),
  key varchar2(32767),
  value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_tag_t (
    namespace varchar2,
    key varchar2,
    value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_tag_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_tag_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_tag_t) NOT PERSISTABLE;

The custom table for Cost Analysis UI rendering.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_saved_custom_table_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  row_group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  column_group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
  compartment_depth number,
  version number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_saved_custom_table_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_saved_custom_table_t (
    display_name varchar2,
    row_group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    column_group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
    compartment_depth number,
    version number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

New custom table detail.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_create_custom_table_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  saved_report_id varchar2(32767),
  saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_custom_table_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_custom_table_details_t (
    compartment_id varchar2,
    saved_report_id varchar2,
    saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Forecast configuration of usage/cost.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_forecast_t FORCE AUTHID CURRENT_USER IS OBJECT (
  forecast_type varchar2(32767),
  time_forecast_started timestamp with time zone,
  time_forecast_ended timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_forecast_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_forecast_t (
    forecast_type varchar2,
    time_forecast_started timestamp with time zone,
    time_forecast_ended timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The dimension used for filtering. Availabe dimensions are: \"service\", \"skuName\", \"skuPartNumber\", \"unit\", \"compartmentName\", \"compartmentPath\", \"compartmentId\", \"platform\", \"region\", \"logicalAd\", \"resourceId\", \"tenantId\", and \"tenantName\". For example: `[{value: \"COMPUTE\", key: \"service\"}]`

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_dimension_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_dimension_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_dimension_t (
    key varchar2,
    value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_dimension_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_dimension_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_dimension_t) NOT PERSISTABLE;

The filter object for query usage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_filter_abs_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operator varchar2(32767),
  dimensions dbms_cloud_oci_usageapi_dimension_tbl,
  tags dbms_cloud_oci_usageapi_tag_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_filter_abs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_filter_abs_t (
    operator varchar2,
    dimensions dbms_cloud_oci_usageapi_dimension_tbl,
    tags dbms_cloud_oci_usageapi_tag_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_usageapi_filter_abs_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_filter_abs_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_filter_abs_t) NOT PERSISTABLE;

The filter object for query usage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_filter_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_usageapi_filter_abs_t (
  filters dbms_cloud_oci_usageapi_filter_abs_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_filter_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_filter_t (
    operator varchar2,
    dimensions dbms_cloud_oci_usageapi_dimension_tbl,
    tags dbms_cloud_oci_usageapi_tag_tbl,
    filters dbms_cloud_oci_usageapi_filter_abs_tbl
  ) RETURN SELF AS RESULT
);

Fields

Nested table type of dbms_cloud_oci_usageapi_filter_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_filter_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_filter_t) NOT PERSISTABLE;

The request of the generated Cost Analysis report.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_report_query_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tenant_id varchar2(32767),
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  granularity varchar2(32767),
  is_aggregate_by_time number,
  forecast dbms_cloud_oci_usageapi_forecast_t,
  query_type varchar2(32767),
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
  compartment_depth number,
  filter dbms_cloud_oci_usageapi_filter_t,
  date_range_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_report_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_report_query_t (
    tenant_id varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone,
    granularity varchar2,
    is_aggregate_by_time number,
    forecast dbms_cloud_oci_usageapi_forecast_t,
    query_type varchar2,
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
    compartment_depth number,
    filter dbms_cloud_oci_usageapi_filter_t,
    date_range_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The common fields for queries.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_query_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  report_query dbms_cloud_oci_usageapi_report_query_t,
  cost_analysis_ui dbms_cloud_oci_usageapi_cost_analysis_ui_t,
  version number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_definition_t (
    display_name varchar2,
    report_query dbms_cloud_oci_usageapi_report_query_t,
    cost_analysis_ui dbms_cloud_oci_usageapi_cost_analysis_ui_t,
    version number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

New query detail with savedRequestSummarizedUsagesDetails, savedCostAnalysisUI, and displayName.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_create_query_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  query_definition dbms_cloud_oci_usageapi_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_query_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_query_details_t (
    compartment_id varchar2,
    query_definition dbms_cloud_oci_usageapi_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The location where usage or cost CSVs will be uploaded defined by `locationType`, which corresponds with type-specific characteristics.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_result_location_t FORCE AUTHID CURRENT_USER IS OBJECT (
  location_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_result_location_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_result_location_t (
    location_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Static or dynamic date range `dateRangeType`, which corresponds with type-specific characteristics.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_date_range_t FORCE AUTHID CURRENT_USER IS OBJECT (
  date_range_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_date_range_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_date_range_t (
    date_range_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The query properties.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_query_properties_t FORCE AUTHID CURRENT_USER IS OBJECT (
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
  filter dbms_cloud_oci_usageapi_filter_t,
  compartment_depth number,
  granularity varchar2(32767),
  query_type varchar2(32767),
  is_aggregate_by_time number,
  date_range dbms_cloud_oci_usageapi_date_range_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_properties_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_properties_t (
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
    filter dbms_cloud_oci_usageapi_filter_t,
    compartment_depth number,
    granularity varchar2,
    query_type varchar2,
    is_aggregate_by_time number,
    date_range dbms_cloud_oci_usageapi_date_range_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The saved schedule.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_create_schedule_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  output_file_format varchar2(32767),
  saved_report_id varchar2(32767),
  result_location dbms_cloud_oci_usageapi_result_location_t,
  schedule_recurrences varchar2(32767),
  time_scheduled timestamp with time zone,
  query_properties dbms_cloud_oci_usageapi_query_properties_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_schedule_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_schedule_details_t (
    name varchar2,
    compartment_id varchar2,
    description varchar2,
    output_file_format varchar2,
    saved_report_id varchar2,
    result_location dbms_cloud_oci_usageapi_result_location_t,
    schedule_recurrences varchar2,
    time_scheduled timestamp with time zone,
    query_properties dbms_cloud_oci_usageapi_query_properties_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The request of the generated usage carbon emissions report.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emissions_report_query_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tenant_id varchar2(32767),
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  is_aggregate_by_time number,
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
  compartment_depth number,
  filter dbms_cloud_oci_usageapi_filter_t,
  date_range_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_report_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_report_query_t (
    tenant_id varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone,
    is_aggregate_by_time number,
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
    compartment_depth number,
    filter dbms_cloud_oci_usageapi_filter_t,
    date_range_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The common fields for queries.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  report_query dbms_cloud_oci_usageapi_usage_carbon_emissions_report_query_t,
  cost_analysis_ui dbms_cloud_oci_usageapi_cost_analysis_ui_t,
  version number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t (
    display_name varchar2,
    report_query dbms_cloud_oci_usageapi_usage_carbon_emissions_report_query_t,
    cost_analysis_ui dbms_cloud_oci_usageapi_cost_analysis_ui_t,
    version number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

New query detail with savedRequestUsageCarbonEmissionsDetails, savedCostAnalysisUI, and displayName.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_create_usage_carbon_emissions_query_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_usage_carbon_emissions_query_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_create_usage_carbon_emissions_query_details_t (
    compartment_id varchar2,
    query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The saved custom table.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_custom_table_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  saved_report_id varchar2(32767),
  compartment_id varchar2(32767),
  saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_custom_table_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_custom_table_t (
    id varchar2,
    saved_report_id varchar2,
    compartment_id varchar2,
    saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Custom table in the list request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_custom_table_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_custom_table_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_custom_table_summary_t (
    id varchar2,
    saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_custom_table_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_custom_table_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_custom_table_summary_t) NOT PERSISTABLE;

A custom table list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_custom_table_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_usageapi_custom_table_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_custom_table_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_custom_table_collection_t (
    items dbms_cloud_oci_usageapi_custom_table_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The saved dynamic date range (required when the static date range is missing).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_dynamic_date_range_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_usageapi_date_range_t (
  dynamic_date_range_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_dynamic_date_range_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_dynamic_date_range_t (
    date_range_type varchar2,
    dynamic_date_range_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_usageapi_dynamic_date_range_t is a subtype of the dbms_cloud_oci_usageapi_date_range_t type.

Fields

Erorr details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_error_t (
    code varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The object storage location where usage or cost CSVs will be uploaded.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_object_storage_location_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_usageapi_result_location_t (
  l_region varchar2(32767),
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_object_storage_location_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_object_storage_location_t (
    location_type varchar2,
    l_region varchar2,
    namespace varchar2,
    bucket_name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_usageapi_object_storage_location_t is a subtype of the dbms_cloud_oci_usageapi_result_location_t type.

Fields

The query to filter and aggregate.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_query_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  query_definition dbms_cloud_oci_usageapi_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_t (
    id varchar2,
    compartment_id varchar2,
    query_definition dbms_cloud_oci_usageapi_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Query summery in the list request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_query_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  query_definition dbms_cloud_oci_usageapi_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_summary_t (
    id varchar2,
    query_definition dbms_cloud_oci_usageapi_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_query_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_query_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_query_summary_t) NOT PERSISTABLE;

A query list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_query_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_usageapi_query_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_query_collection_t (
    items dbms_cloud_oci_usageapi_query_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for the '/usage' query.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_request_summarized_usages_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tenant_id varchar2(32767),
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  granularity varchar2(32767),
  is_aggregate_by_time number,
  forecast dbms_cloud_oci_usageapi_forecast_t,
  query_type varchar2(32767),
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
  compartment_depth number,
  filter dbms_cloud_oci_usageapi_filter_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_request_summarized_usages_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_request_summarized_usages_details_t (
    tenant_id varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone,
    granularity varchar2,
    is_aggregate_by_time number,
    forecast dbms_cloud_oci_usageapi_forecast_t,
    query_type varchar2,
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
    compartment_depth number,
    filter dbms_cloud_oci_usageapi_filter_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for the '/usageCarbonEmissions' query.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_request_usage_carbon_emissions_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tenant_id varchar2(32767),
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  is_aggregate_by_time number,
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
  compartment_depth number,
  filter dbms_cloud_oci_usageapi_filter_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_request_usage_carbon_emissions_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_request_usage_carbon_emissions_details_t (
    tenant_id varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone,
    is_aggregate_by_time number,
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    group_by_tag dbms_cloud_oci_usageapi_tag_tbl,
    compartment_depth number,
    filter dbms_cloud_oci_usageapi_filter_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The schedule.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_schedule_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  compartment_id varchar2(32767),
  result_location dbms_cloud_oci_usageapi_result_location_t,
  description varchar2(32767),
  time_next_run timestamp with time zone,
  output_file_format varchar2(32767),
  saved_report_id varchar2(32767),
  schedule_recurrences varchar2(32767),
  time_scheduled timestamp with time zone,
  query_properties dbms_cloud_oci_usageapi_query_properties_t,
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_schedule_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_schedule_t (
    id varchar2,
    name varchar2,
    compartment_id varchar2,
    result_location dbms_cloud_oci_usageapi_result_location_t,
    description varchar2,
    time_next_run timestamp with time zone,
    output_file_format varchar2,
    saved_report_id varchar2,
    schedule_recurrences varchar2,
    time_scheduled timestamp with time zone,
    query_properties dbms_cloud_oci_usageapi_query_properties_t,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Schedule summary for the list schedule.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_schedule_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  time_next_run timestamp with time zone,
  schedule_recurrences varchar2(32767),
  time_scheduled timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_schedule_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_schedule_summary_t (
    id varchar2,
    name varchar2,
    description varchar2,
    time_next_run timestamp with time zone,
    schedule_recurrences varchar2,
    time_scheduled timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_schedule_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_schedule_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_schedule_summary_t) NOT PERSISTABLE;

A schedule collection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_schedule_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_usageapi_schedule_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_schedule_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_schedule_collection_t (
    items dbms_cloud_oci_usageapi_schedule_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The saved schedule run.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_scheduled_run_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  schedule_id varchar2(32767),
  time_created timestamp with time zone,
  time_finished timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_scheduled_run_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_scheduled_run_t (
    id varchar2,
    schedule_id varchar2,
    time_created timestamp with time zone,
    time_finished timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The saved history past run.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_scheduled_run_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  schedule_id varchar2(32767),
  time_created timestamp with time zone,
  time_finished timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_scheduled_run_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_scheduled_run_summary_t (
    id varchar2,
    schedule_id varchar2,
    time_created timestamp with time zone,
    time_finished timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_scheduled_run_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_scheduled_run_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_scheduled_run_summary_t) NOT PERSISTABLE;

The schedule past run list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_scheduled_run_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_usageapi_scheduled_run_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_scheduled_run_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_scheduled_run_collection_t (
    items dbms_cloud_oci_usageapi_scheduled_run_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The saved static date range (required when the dynamic date range is missing).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_static_date_range_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_usageapi_date_range_t (
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_static_date_range_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_static_date_range_t (
    date_range_type varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_usageapi_static_date_range_t is a subtype of the dbms_cloud_oci_usageapi_date_range_t type.

Fields

Details for updating the custom table.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_update_custom_table_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_custom_table_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_custom_table_details_t (
    saved_custom_table dbms_cloud_oci_usageapi_saved_custom_table_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for the query to update reportQuery, costAnalysisUI, and displayName.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_update_query_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  query_definition dbms_cloud_oci_usageapi_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_query_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_query_details_t (
    query_definition dbms_cloud_oci_usageapi_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for updating the custom table.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_update_schedule_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  description varchar2(32767),
  output_file_format varchar2(32767),
  result_location dbms_cloud_oci_usageapi_result_location_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_schedule_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_schedule_details_t (
    description varchar2,
    output_file_format varchar2,
    result_location dbms_cloud_oci_usageapi_result_location_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for the query to update usageCarbonEmissionsQuery, costAnalysisUI, and displayName.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_update_usage_carbon_emissions_query_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_usage_carbon_emissions_query_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_update_usage_carbon_emissions_query_details_t (
    query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The usage store result.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tenant_id varchar2(32767),
  tenant_name varchar2(32767),
  compartment_id varchar2(32767),
  compartment_path varchar2(32767),
  compartment_name varchar2(32767),
  service varchar2(32767),
  resource_name varchar2(32767),
  resource_id varchar2(32767),
  l_region varchar2(32767),
  ad varchar2(32767),
  weight number,
  shape varchar2(32767),
  sku_part_number varchar2(32767),
  sku_name varchar2(32767),
  unit varchar2(32767),
  discount number,
  list_rate number,
  platform varchar2(32767),
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  computed_amount number,
  computed_quantity number,
  overages_flag varchar2(32767),
  unit_price number,
  currency varchar2(32767),
  subscription_id varchar2(32767),
  overage varchar2(32767),
  is_forecast number,
  tags dbms_cloud_oci_usageapi_tag_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_summary_t (
    tenant_id varchar2,
    tenant_name varchar2,
    compartment_id varchar2,
    compartment_path varchar2,
    compartment_name varchar2,
    service varchar2,
    resource_name varchar2,
    resource_id varchar2,
    l_region varchar2,
    ad varchar2,
    weight number,
    shape varchar2,
    sku_part_number varchar2,
    sku_name varchar2,
    unit varchar2,
    discount number,
    list_rate number,
    platform varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone,
    computed_amount number,
    computed_quantity number,
    overages_flag varchar2,
    unit_price number,
    currency varchar2,
    subscription_id varchar2,
    overage varchar2,
    is_forecast number,
    tags dbms_cloud_oci_usageapi_tag_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_usage_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_usage_summary_t) NOT PERSISTABLE;

The account (tenant) usage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  items dbms_cloud_oci_usageapi_usage_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_aggregation_t (
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    items dbms_cloud_oci_usageapi_usage_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The usage carbon emission store result.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emission_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tenant_id varchar2(32767),
  tenant_name varchar2(32767),
  compartment_id varchar2(32767),
  compartment_path varchar2(32767),
  compartment_name varchar2(32767),
  service varchar2(32767),
  resource_name varchar2(32767),
  resource_id varchar2(32767),
  l_region varchar2(32767),
  ad varchar2(32767),
  sku_part_number varchar2(32767),
  sku_name varchar2(32767),
  platform varchar2(32767),
  time_usage_started timestamp with time zone,
  time_usage_ended timestamp with time zone,
  computed_carbon_emission number,
  emission_calculation_method varchar2(32767),
  subscription_id varchar2(32767),
  tags dbms_cloud_oci_usageapi_tag_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emission_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emission_summary_t (
    tenant_id varchar2,
    tenant_name varchar2,
    compartment_id varchar2,
    compartment_path varchar2,
    compartment_name varchar2,
    service varchar2,
    resource_name varchar2,
    resource_id varchar2,
    l_region varchar2,
    ad varchar2,
    sku_part_number varchar2,
    sku_name varchar2,
    platform varchar2,
    time_usage_started timestamp with time zone,
    time_usage_ended timestamp with time zone,
    computed_carbon_emission number,
    emission_calculation_method varchar2,
    subscription_id varchar2,
    tags dbms_cloud_oci_usageapi_tag_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_usage_carbon_emission_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emission_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_usage_carbon_emission_summary_t) NOT PERSISTABLE;

The account (tenant) usage carbon emissions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emission_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  group_by dbms_cloud_oci_usageapi_varchar2_tbl,
  items dbms_cloud_oci_usageapi_usage_carbon_emission_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emission_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emission_aggregation_t (
    group_by dbms_cloud_oci_usageapi_varchar2_tbl,
    items dbms_cloud_oci_usageapi_usage_carbon_emission_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The usage carbon emissions saved query to filter and aggregate.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emissions_query_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_t (
    id varchar2,
    compartment_id varchar2,
    query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Usage carbon emissions query summary in the list request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_t (
    id varchar2,
    query_definition dbms_cloud_oci_usageapi_usage_carbon_emissions_query_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_t) NOT PERSISTABLE;

A usage carbon emissions query list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_usageapi_usage_carbon_emissions_query_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_usageapi_usage_carbon_emissions_query_collection_t (
    items dbms_cloud_oci_usageapi_usage_carbon_emissions_query_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields