Nested table type of varchar2(32767).

Syntax

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

Information about the database system associated with a backup.

Syntax

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

Fields

Database system backup information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_backup_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  source_type varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  retention_period number,
  backup_size number,
  db_system_id varchar2(32767),
  db_system_details dbms_cloud_oci_psql_db_system_details_t,
  last_accepted_request_token varchar2(32767),
  last_completed_request_token varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_backup_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_backup_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    source_type varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    retention_period number,
    backup_size number,
    db_system_id varchar2,
    db_system_details dbms_cloud_oci_psql_db_system_details_t,
    last_accepted_request_token varchar2,
    last_completed_request_token varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary information for a backup.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_backup_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  source_type varchar2(32767),
  backup_size number,
  db_system_id varchar2(32767),
  retention_period number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_backup_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_backup_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    source_type varchar2,
    backup_size number,
    db_system_id varchar2,
    retention_period number,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_backup_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_backup_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_backup_summary_t) NOT PERSISTABLE;

Results of a backup search. Contains the BackupSummary items and other information, such as metadata.

Syntax

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

Fields

PostgreSQL database system backup policy.

Syntax

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

Fields

The source used to restore the database system.

Syntax

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

Fields

Restoring to a new database system from the backup. The database system details that are part of the CreateDbSystem request are not required, but if present will override the details from the backup's database system snapshot.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_backup_source_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_source_details_t (
  backup_id varchar2(32767),
  is_having_restore_config_overrides number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_backup_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_backup_source_details_t (
    source_type varchar2,
    backup_id varchar2,
    is_having_restore_config_overrides number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_backup_source_details_t is a subtype of the dbms_cloud_oci_psql_source_details_t type.

Fields

The information used to move a backup to a different compartment.

Syntax

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

Fields

The information to move a configuration to a different compartment.

Syntax

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

Fields

Change database system compartment operation details.

Syntax

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

Fields

Configuration overrides for a PostgreSQL instance.

Syntax

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

Fields

Database configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_config_params_t FORCE AUTHID CURRENT_USER IS OBJECT (
  config_key varchar2(32767),
  default_config_value varchar2(32767),
  overriden_config_value varchar2(32767),
  allowed_values varchar2(32767),
  is_restart_required number,
  data_type varchar2(32767),
  is_overridable number,
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_config_params_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_config_params_t (
    config_key varchar2,
    default_config_value varchar2,
    overriden_config_value varchar2,
    allowed_values varchar2,
    is_restart_required number,
    data_type varchar2,
    is_overridable number,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_config_params_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_config_params_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_config_params_t) NOT PERSISTABLE;

List of configuration details.

Syntax

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

Fields

PostgreSQL configuration for a database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  shape varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  db_version varchar2(32767),
  configuration_details dbms_cloud_oci_psql_configuration_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_configuration_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    shape varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    db_version varchar2,
    configuration_details dbms_cloud_oci_psql_configuration_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_configuration_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  shape varchar2(32767),
  db_version varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_configuration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_configuration_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    shape varchar2,
    db_version varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_configuration_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_configuration_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_configuration_summary_t) NOT PERSISTABLE;

Results of a configuration search. Contains the ConfigurationSummary items and other information, such as metadata.

Syntax

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

Fields

Information about the database instance node endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  fqdn varchar2(32767),
  ip_address varchar2(32767),
  port number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_endpoint_t (
    fqdn varchar2,
    ip_address varchar2,
    port number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The database instance node endpoint information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_db_instance_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  db_instance_id varchar2(32767),
  endpoint dbms_cloud_oci_psql_endpoint_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_db_instance_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_db_instance_endpoint_t (
    db_instance_id varchar2,
    endpoint dbms_cloud_oci_psql_endpoint_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_db_instance_endpoint_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_db_instance_endpoint_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_db_instance_endpoint_t) NOT PERSISTABLE;

Database system connection information. Used to connect to PostgreSQL instance(s).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  ca_certificate varchar2(32767),
  primary_db_endpoint dbms_cloud_oci_psql_endpoint_t,
  instance_endpoints dbms_cloud_oci_psql_db_instance_endpoint_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_connection_details_t (
    ca_certificate varchar2,
    primary_db_endpoint dbms_cloud_oci_psql_endpoint_t,
    instance_endpoints dbms_cloud_oci_psql_db_instance_endpoint_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information to create a new backup.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_create_backup_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  db_system_id varchar2(32767),
  retention_period number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_backup_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_backup_details_t (
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    db_system_id varchar2,
    retention_period number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_config_overrides_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_config_overrides_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_config_overrides_t) NOT PERSISTABLE;

Configuration overrides for a PostgreSQL instance.

Syntax

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

Fields

The information to create a new configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_create_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  shape varchar2(32767),
  db_version varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  db_configuration_overrides dbms_cloud_oci_psql_db_configuration_override_collection_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_configuration_details_t (
    display_name varchar2,
    compartment_id varchar2,
    description varchar2,
    shape varchar2,
    db_version varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    db_configuration_overrides dbms_cloud_oci_psql_db_configuration_override_collection_t,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information about the new database instance node.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_create_db_instance_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  private_ip varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_db_instance_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_db_instance_details_t (
    display_name varchar2,
    description varchar2,
    private_ip varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Storage details of the database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_storage_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  system_type varchar2(32767),
  is_regionally_durable number,
  availability_domain varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_storage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_storage_details_t (
    system_type varchar2,
    is_regionally_durable number,
    availability_domain varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Details for the database system password. Password can be passed as `VaultSecretPasswordDetails` or `PlainTextPasswordDetails`.

Syntax

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

Fields

Initial database system credentials that the database system will be provisioned with. The password details are not visible on any subsequent operation, such as GET /dbSystems/{dbSystemId}.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  password_details dbms_cloud_oci_psql_password_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_credentials_t (
    username varchar2,
    password_details dbms_cloud_oci_psql_password_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Network details for the database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_network_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  subnet_id varchar2(32767),
  primary_db_endpoint_private_ip varchar2(32767),
  nsg_ids dbms_cloud_oci_psql_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_network_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_network_details_t (
    subnet_id varchar2,
    primary_db_endpoint_private_ip varchar2,
    nsg_ids dbms_cloud_oci_psql_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

PostgreSQL database system management policy update details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_management_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  maintenance_window_start varchar2(32767),
  backup_policy dbms_cloud_oci_psql_backup_policy_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_management_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_management_policy_details_t (
    maintenance_window_start varchar2,
    backup_policy dbms_cloud_oci_psql_backup_policy_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_create_db_instance_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_create_db_instance_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_create_db_instance_details_t) NOT PERSISTABLE;

The information about new database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_create_db_system_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  system_type varchar2(32767),
  db_version varchar2(32767),
  config_id varchar2(32767),
  storage_details dbms_cloud_oci_psql_storage_details_t,
  shape varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  instance_count number,
  instances_details dbms_cloud_oci_psql_create_db_instance_details_tbl,
  credentials dbms_cloud_oci_psql_credentials_t,
  network_details dbms_cloud_oci_psql_network_details_t,
  management_policy dbms_cloud_oci_psql_management_policy_details_t,
  source dbms_cloud_oci_psql_source_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_db_system_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_create_db_system_details_t (
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    system_type varchar2,
    db_version varchar2,
    config_id varchar2,
    storage_details dbms_cloud_oci_psql_storage_details_t,
    shape varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    instance_count number,
    instances_details dbms_cloud_oci_psql_create_db_instance_details_tbl,
    credentials dbms_cloud_oci_psql_credentials_t,
    network_details dbms_cloud_oci_psql_network_details_t,
    management_policy dbms_cloud_oci_psql_management_policy_details_t,
    source dbms_cloud_oci_psql_source_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Daily backup policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_daily_backup_policy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_backup_policy_t (
  backup_start varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_daily_backup_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_daily_backup_policy_t (
    kind varchar2,
    retention_days number,
    backup_start varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_daily_backup_policy_t is a subtype of the dbms_cloud_oci_psql_backup_policy_t type.

Fields

Information about a database instance node.

Syntax

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

Fields

PostgreSQL database system management policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_management_policy_t FORCE AUTHID CURRENT_USER IS OBJECT (
  maintenance_window_start varchar2(32767),
  backup_policy dbms_cloud_oci_psql_backup_policy_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_management_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_management_policy_t (
    maintenance_window_start varchar2,
    backup_policy dbms_cloud_oci_psql_backup_policy_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_db_instance_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_db_instance_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_db_instance_t) NOT PERSISTABLE;

Information about a database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_db_system_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  admin_username varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  system_type varchar2(32767),
  db_version varchar2(32767),
  config_id varchar2(32767),
  shape varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  instance_count number,
  instances dbms_cloud_oci_psql_db_instance_tbl,
  storage_details dbms_cloud_oci_psql_storage_details_t,
  network_details dbms_cloud_oci_psql_network_details_t,
  management_policy dbms_cloud_oci_psql_management_policy_t,
  source dbms_cloud_oci_psql_source_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_db_system_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_db_system_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    admin_username varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    system_type varchar2,
    db_version varchar2,
    config_id varchar2,
    shape varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    instance_count number,
    instances dbms_cloud_oci_psql_db_instance_tbl,
    storage_details dbms_cloud_oci_psql_storage_details_t,
    network_details dbms_cloud_oci_psql_network_details_t,
    management_policy dbms_cloud_oci_psql_management_policy_t,
    source dbms_cloud_oci_psql_source_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary information about a database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_db_system_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  system_type varchar2(32767),
  instance_count number,
  shape varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  db_version varchar2(32767),
  config_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_db_system_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_db_system_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    system_type varchar2,
    instance_count number,
    shape varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    db_version varchar2,
    config_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_db_system_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_db_system_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_db_system_summary_t) NOT PERSISTABLE;

Results of a database system search. Contains both DbSystemSummary items and other information, such as metadata.

Syntax

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

Fields

Default database configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_default_config_params_t FORCE AUTHID CURRENT_USER IS OBJECT (
  config_key varchar2(32767),
  default_config_value varchar2(32767),
  allowed_values varchar2(32767),
  is_restart_required number,
  data_type varchar2(32767),
  is_overridable number,
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_default_config_params_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_default_config_params_t (
    config_key varchar2,
    default_config_value varchar2,
    allowed_values varchar2,
    is_restart_required number,
    data_type varchar2,
    is_overridable number,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_default_config_params_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_default_config_params_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_default_config_params_t) NOT PERSISTABLE;

List of default configuration values for databases.

Syntax

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

Fields

Default configurations for PostgreSQL database systems.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_default_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  shape varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  db_version varchar2(32767),
  configuration_details dbms_cloud_oci_psql_default_configuration_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_default_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_default_configuration_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    shape varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number,
    db_version varchar2,
    configuration_details dbms_cloud_oci_psql_default_configuration_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_default_configuration_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  shape varchar2(32767),
  db_version varchar2(32767),
  instance_ocpu_count number,
  instance_memory_size_in_g_bs number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_default_configuration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_default_configuration_summary_t (
    id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    shape varchar2,
    db_version varchar2,
    instance_ocpu_count number,
    instance_memory_size_in_g_bs number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_default_configuration_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_default_configuration_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_default_configuration_summary_t) NOT PERSISTABLE;

Results of a configuration search. Contains the ConfigurationSummary items and other information, such as metadata.

Syntax

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

Fields

Error Information.

Syntax

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

Fields

Database system failover information.

Syntax

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

Fields

Nested table type of number.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_number_tbl FORCE IS TABLE OF (number) NOT PERSISTABLE;

Monthly backup policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_monthly_backup_policy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_backup_policy_t (
  backup_start varchar2(32767),
  days_of_the_month dbms_cloud_oci_psql_number_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_monthly_backup_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_monthly_backup_policy_t (
    kind varchar2,
    retention_days number,
    backup_start varchar2,
    days_of_the_month dbms_cloud_oci_psql_number_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_monthly_backup_policy_t is a subtype of the dbms_cloud_oci_psql_backup_policy_t type.

Fields

No backup policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_none_backup_policy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_backup_policy_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_none_backup_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_none_backup_policy_t (
    kind varchar2,
    retention_days number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_none_backup_policy_t is a subtype of the dbms_cloud_oci_psql_backup_policy_t type.

This is used to create new database system or update without restoring from backup.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_none_source_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_source_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_none_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_none_source_details_t (
    source_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_none_source_details_t is a subtype of the dbms_cloud_oci_psql_source_details_t type.

Storage details of the database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_oci_optimized_storage_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_storage_details_t (
  iops number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_oci_optimized_storage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_oci_optimized_storage_details_t (
    system_type varchar2,
    is_regionally_durable number,
    availability_domain varchar2,
    iops number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_oci_optimized_storage_details_t is a subtype of the dbms_cloud_oci_psql_storage_details_t type.

Fields

A single instruction to be included as part of Patch request content.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_psql_patch_instruction_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_instruction_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_patch_instruction_t) NOT PERSISTABLE;

For adding read replica database instances, the operation is INSERT and value object to specify is #/definitions/CreateDbInstanceDetails. For removing read replica database instances, the operation is REMOVE and value object needs to be an array of dbInstanceId's.

Syntax

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

Fields

An operation that inserts a value into an array, shifting array items as necessary and handling NOT_FOUND exceptions by creating the implied containing structure.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_insert_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  value json_element_t,
  selected_item varchar2(32767),
  position varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_insert_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_insert_instruction_t (
    operation varchar2,
    selection varchar2,
    value json_element_t,
    selected_item varchar2,
    position varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_insert_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

Fields

An operation that recursively updates items of the selection, or adding the value if the selection is empty. If the value is not an object, it is used directly, otherwise each key-value member is used to create or update a member of the same name in the target and the same process is applied recursively for each object-typed value (similar to RFC 7396 JSON Merge Patch, except that null values are copied rather than transformed into deletions). NOT_FOUND exceptions are handled by creating the implied containing structure. To avoid referential errors if an item's descendant is also in the selection, items of the selection are processed in order of decreasing depth.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_merge_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  value json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_merge_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_merge_instruction_t (
    operation varchar2,
    selection varchar2,
    value json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_merge_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

Fields

An operation that \"puts\" values from elsewhere in the target, functionally equivalent to a single add and then a remove. The first item of the selection is replaced, or created if the selection is empty. NOT_FOUND exceptions in the selection are handled by creating the implied containing structure. This operation fails if the `from` selection yields any exceptions, or if an item is moved to any of its descendants.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_move_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  l_from varchar2(32767),
  position varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_move_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_move_instruction_t (
    operation varchar2,
    selection varchar2,
    l_from varchar2,
    position varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_move_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

Fields

A precondition operation that requires a selection to be empty, or optionally to be non-empty but include no item with a specified value (useful for asserting that a value does not exist before attempting to create it, avoiding accidental update). It fails if value is provided and the selection includes an item matching it, or if value is not provided and the selection is not empty, but ignores NOT_FOUND exceptions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_prohibit_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  value json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_prohibit_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_prohibit_instruction_t (
    operation varchar2,
    selection varchar2,
    value json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_prohibit_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

Fields

An operation that deletes items, ignoring NOT_FOUND exceptions. To avoid referential errors if an item's descendant is also in the selection, items of the selection are processed in order of decreasing depth.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_remove_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_remove_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_remove_instruction_t (
    operation varchar2,
    selection varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_remove_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

An operation that \"puts\" a value, replacing every item of the selection with it, or creating it if the selection is empty. NOT_FOUND exceptions are handled by creating the implied containing structure (but note that this may put the target in an invalid state, which can be prevented by use of precondition operations). To avoid referential errors if an item's descendant is also in the selection, items of the selection are processed in order of decreasing depth.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_replace_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  value json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_replace_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_replace_instruction_t (
    operation varchar2,
    selection varchar2,
    value json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_replace_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

Fields

A precondition operation that requires a selection to be non-empty, and optionally to include an item with a specified value (useful for asserting that a value exists before attempting to update it, avoiding accidental creation). It fails if the selection is empty, or if value is provided and no item of the selection matches it.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_patch_require_instruction_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_patch_instruction_t (
  value json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_require_instruction_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_patch_require_instruction_t (
    operation varchar2,
    selection varchar2,
    value json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_patch_require_instruction_t is a subtype of the dbms_cloud_oci_psql_patch_instruction_t type.

Fields

Details for in-line database system password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_plain_text_password_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_password_details_t (
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_plain_text_password_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_plain_text_password_details_t (
    password_type varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_plain_text_password_details_t is a subtype of the dbms_cloud_oci_psql_password_details_t type.

Fields

The primary database instance node details.

Syntax

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

Fields

Password detail that will be used to reset the database system's master user. These details are not visible on any subsequent operation, such as GET /dbSystems/{dbSystemId}.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_reset_master_user_password_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  password_details dbms_cloud_oci_psql_password_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_reset_master_user_password_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_reset_master_user_password_details_t (
    password_details dbms_cloud_oci_psql_password_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database instance node restart parameters.

Syntax

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

Fields

Backup details to restore the database system.

Syntax

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

Fields

Summary of the database system shape.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_shape_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  shape varchar2(32767),
  ocpu_count number,
  memory_size_in_g_bs number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_shape_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_shape_summary_t (
    id varchar2,
    shape varchar2,
    ocpu_count number,
    memory_size_in_g_bs number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_shape_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_shape_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_shape_summary_t) NOT PERSISTABLE;

The list of shapes that can be used to create a database system.

Syntax

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

Fields

The backup information to be updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_update_backup_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  retention_period number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_update_backup_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_update_backup_details_t (
    display_name varchar2,
    description varchar2,
    retention_period number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information to update a configuration.

Syntax

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

Fields

Configuration for the PostgreSQL database instance.

Syntax

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

Fields

Database instance node update parameters.

Syntax

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

Fields

Storage details of the database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_update_storage_details_params_t FORCE AUTHID CURRENT_USER IS OBJECT (
  iops number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_update_storage_details_params_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_update_storage_details_params_t (
    iops number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information to be updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_update_db_system_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  db_configuration_params dbms_cloud_oci_psql_update_db_config_params_t,
  management_policy dbms_cloud_oci_psql_management_policy_details_t,
  storage_details dbms_cloud_oci_psql_update_storage_details_params_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_update_db_system_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_update_db_system_details_t (
    display_name varchar2,
    description varchar2,
    db_configuration_params dbms_cloud_oci_psql_update_db_config_params_t,
    management_policy dbms_cloud_oci_psql_management_policy_details_t,
    storage_details dbms_cloud_oci_psql_update_storage_details_params_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Secret details for the database system password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_vault_secret_password_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_password_details_t (
  secret_id varchar2(32767),
  secret_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_vault_secret_password_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_vault_secret_password_details_t (
    password_type varchar2,
    secret_id varchar2,
    secret_version varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_vault_secret_password_details_t is a subtype of the dbms_cloud_oci_psql_password_details_t type.

Fields

Weekly backup policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_weekly_backup_policy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_psql_backup_policy_t (
  days_of_the_week dbms_cloud_oci_psql_varchar2_tbl,
  backup_start varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_weekly_backup_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_weekly_backup_policy_t (
    kind varchar2,
    retention_days number,
    days_of_the_week dbms_cloud_oci_psql_varchar2_tbl,
    backup_start varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_psql_weekly_backup_policy_t is a subtype of the dbms_cloud_oci_psql_backup_policy_t type.

Fields

A resource created or operated on by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_type varchar2(32767),
  action_type varchar2(32767),
  identifier varchar2(32767),
  entity_uri varchar2(32767),
  metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    identifier varchar2,
    entity_uri varchar2,
    metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_work_request_resource_t) NOT PERSISTABLE;

An asynchronous work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_psql_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_psql_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_work_request_error_t) NOT PERSISTABLE;

Results of a workRequestError search. Contains both WorkRequestError items and other information, such as metadata.

Syntax

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

Fields

A log message from the execution of a work request.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_psql_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_work_request_log_entry_t) NOT PERSISTABLE;

Results of a workRequestLog search. Contains both workRequestLog items and other information, such as metadata.

Syntax

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

Fields

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_psql_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_psql_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_psql_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_psql_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_psql_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_psql_work_request_summary_t) NOT PERSISTABLE;

Results of a workRequest search. Contains both WorkRequest items and other information, such as metadata.

Syntax

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

Fields