Nested table type of varchar2(32767).

Syntax

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

Syntax

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

Fields

Contains the details for the compartment to move the `DatabaseToolsConnection` to.

Syntax

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

Fields

Contains the details for the compartment to move the Database Tools private endpoint to.

Syntax

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

Fields

Resource locks are used to prevent certain APIs from being called for the resource. A full lock prevents both updating the resource and deleting the resource. A delete lock prevents deleting the resource.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_tools_resource_lock_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_resource_lock_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_resource_lock_t) NOT PERSISTABLE;

Details for the new Database Tools connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_create_database_tools_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  locks dbms_cloud_oci_database_tools_resource_lock_tbl,
  l_type varchar2(32767),
  runtime_support varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_details_t (
    display_name varchar2,
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The user password.

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_details_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_details_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_t) NOT PERSISTABLE;

Details of the new Database Tools connection for a Generic JDBC database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_create_database_tools_connection_generic_jdbc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_create_database_tools_connection_details_t (
  url varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_generic_jdbc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_generic_jdbc_details_t (
    display_name varchar2,
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    url varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_create_database_tools_connection_generic_jdbc_details_t is a subtype of the dbms_cloud_oci_database_tools_create_database_tools_connection_details_t type.

Fields

The related resource

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_details_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_details_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_t) NOT PERSISTABLE;

Details of the new Database Tools connection for a MySQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_create_database_tools_connection_my_sql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_create_database_tools_connection_details_t (
  related_resource dbms_cloud_oci_database_tools_create_database_tools_related_resource_my_sql_details_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_my_sql_details_t (
    display_name varchar2,
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_create_database_tools_related_resource_my_sql_details_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_create_database_tools_connection_my_sql_details_t is a subtype of the dbms_cloud_oci_database_tools_create_database_tools_connection_details_t type.

Fields

The related resource

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_details_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_details_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_details_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The proxy client information.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_details_t) NOT PERSISTABLE;

Details of the new Database Tools connection for an Oracle Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_create_database_tools_connection_oracle_database_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_create_database_tools_connection_details_t (
  related_resource dbms_cloud_oci_database_tools_create_database_tools_related_resource_details_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_details_tbl,
  private_endpoint_id varchar2(32767),
  proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_oracle_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_oracle_database_details_t (
    display_name varchar2,
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_create_database_tools_related_resource_details_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_details_tbl,
    private_endpoint_id varchar2,
    proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_create_database_tools_connection_oracle_database_details_t is a subtype of the dbms_cloud_oci_database_tools_create_database_tools_connection_details_t type.

Fields

The related resource

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_details_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_details_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_t) NOT PERSISTABLE;

Details of the new Database Tools connection for a PostgreSQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_create_database_tools_connection_postgresql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_create_database_tools_connection_details_t (
  related_resource dbms_cloud_oci_database_tools_create_database_tools_related_resource_postgresql_details_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_postgresql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_connection_postgresql_details_t (
    display_name varchar2,
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_create_database_tools_related_resource_postgresql_details_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_create_database_tools_connection_postgresql_details_t is a subtype of the dbms_cloud_oci_database_tools_create_database_tools_connection_details_t type.

Fields

The details for the new Database Tools private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_create_database_tools_private_endpoint_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  locks dbms_cloud_oci_database_tools_resource_lock_tbl,
  display_name varchar2(32767),
  description varchar2(32767),
  endpoint_service_id varchar2(32767),
  subnet_id varchar2(32767),
  private_endpoint_ip varchar2(32767),
  nsg_ids dbms_cloud_oci_database_tools_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_private_endpoint_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_create_database_tools_private_endpoint_details_t (
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    display_name varchar2,
    description varchar2,
    endpoint_service_id varchar2,
    subnet_id varchar2,
    private_endpoint_ip varchar2,
    nsg_ids dbms_cloud_oci_database_tools_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Description of the Database Tools connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  locks dbms_cloud_oci_database_tools_resource_lock_tbl,
  l_type varchar2(32767),
  runtime_support varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Summary of the Database Tools connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  locks dbms_cloud_oci_database_tools_resource_lock_tbl,
  l_type varchar2(32767),
  runtime_support varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_connection_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_connection_summary_t) NOT PERSISTABLE;

List of `DatabaseToolsConnectionSummary` items.

Syntax

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

Fields

The user password.

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_t) NOT PERSISTABLE;

Database Tools connection of a Generic JDBC database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_t (
  url varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    url varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_t type.

Fields

The user password.

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The summary of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_summary_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_summary_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_summary_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_summary_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_t) NOT PERSISTABLE;

DatabaseToolsConnectionSummary of a Generic JDBC database system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_summary_t (
  url varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    url varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_generic_jdbc_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_summary_t type.

Fields

A related resource

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_t) NOT PERSISTABLE;

Database Tools connection of a MySQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_my_sql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_t (
  related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_my_sql_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_my_sql_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_my_sql_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_my_sql_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_t type.

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The key store secrets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_summary_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_summary_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_summary_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_summary_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_t) NOT PERSISTABLE;

DatabaseToolsConnectionSummary of a MySQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_my_sql_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_summary_t (
  related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_my_sql_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_my_sql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_my_sql_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_my_sql_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_summary_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_my_sql_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_summary_t type.

Fields

A related resource

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The proxy client information.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_t) NOT PERSISTABLE;

Database Tools connection of an Oracle Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_t (
  related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_tbl,
  private_endpoint_id varchar2(32767),
  proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_tbl,
    private_endpoint_id varchar2,
    proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_t type.

Fields

Represents blank proxy client information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_t (
    proxy_authentication_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_t type.

Represents blank proxy client information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_details_t (
    proxy_authentication_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t type.

The proxy client information.

Syntax

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

Fields

Represents blank proxy client information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_summary_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_summary_t (
    proxy_authentication_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_no_proxy_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_summary_t type.

Proxy client information for user name based proxy authentication.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_t (
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
  roles dbms_cloud_oci_database_tools_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_t (
    proxy_authentication_type varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
    roles dbms_cloud_oci_database_tools_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_t type.

Fields

Proxy client information for user name based proxy authentication.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t (
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  roles dbms_cloud_oci_database_tools_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_details_t (
    proxy_authentication_type varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    roles dbms_cloud_oci_database_tools_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t type.

Fields

Proxy client information for user name based proxy authentication.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_summary_t (
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
  roles dbms_cloud_oci_database_tools_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_summary_t (
    proxy_authentication_type varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
    roles dbms_cloud_oci_database_tools_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_user_name_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_summary_t type.

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The key store secrets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_summary_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_summary_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_summary_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_summary_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_summary_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_summary_t) NOT PERSISTABLE;

DatabaseToolsConnectionSummary of an Oracle Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_summary_t (
  related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_summary_tbl,
  private_endpoint_id varchar2(32767),
  proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_summary_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_summary_tbl,
    private_endpoint_id varchar2,
    proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_summary_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_summary_t type.

Fields

A related resource

Syntax

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

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The details of the key store.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_t) NOT PERSISTABLE;

Database Tools connection of a PostgreSQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_postgresql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_t (
  related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_postgresql_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_postgresql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_postgresql_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_postgresql_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_postgresql_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_t type.

Fields

The key store content.

Syntax

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

Fields

The key store password.

Syntax

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

Fields

The key store secrets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key_store_type varchar2(32767),
  key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_summary_t,
  key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_summary_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_t (
    key_store_type varchar2,
    key_store_content dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_summary_t,
    key_store_password dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_summary_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_t) NOT PERSISTABLE;

DatabaseToolsConnectionSummary of a PostgreSQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_connection_postgresql_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_connection_summary_t (
  related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_postgresql_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_postgresql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_connection_postgresql_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    l_type varchar2,
    runtime_support varchar2,
    related_resource dbms_cloud_oci_database_tools_database_tools_related_resource_postgresql_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_summary_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_summary_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_connection_postgresql_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_connection_summary_t type.

Fields

Description of Database Tools Endpoint Service.

Syntax

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

Fields

Summary of the Database Tools Endpoint Service.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_endpoint_service_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_endpoint_service_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_endpoint_service_summary_t) NOT PERSISTABLE;

List of `DatabaseToolsEndpointServiceSummary` items.

Syntax

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

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_details_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_details_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_generic_jdbc_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_generic_jdbc_summary_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_details_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_my_sql_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_my_sql_summary_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_details_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_postgresql_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_postgresql_summary_t type.

Fields

The key store content.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_content_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_content_secret_id_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_content_summary_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_details_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_details_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_generic_jdbc_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_generic_jdbc_summary_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_details_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_my_sql_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_my_sql_summary_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_details_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_postgresql_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_postgresql_summary_t type.

Fields

The key store password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_key_store_password_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_key_store_password_secret_id_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_key_store_password_summary_t type.

Fields

Source IP information for reverse connection configuration.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connections_source_ip_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connections_source_ip_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connections_source_ip_t) NOT PERSISTABLE;

Reverse connection configuration details of the private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  reverse_connections_source_ips dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connections_source_ip_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t (
    reverse_connections_source_ips dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connections_source_ip_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Description of Database Tools private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_private_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  locks dbms_cloud_oci_database_tools_resource_lock_tbl,
  display_name varchar2(32767),
  description varchar2(32767),
  id varchar2(32767),
  endpoint_service_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  private_endpoint_vnic_id varchar2(32767),
  private_endpoint_ip varchar2(32767),
  endpoint_fqdn varchar2(32767),
  additional_fqdns dbms_cloud_oci_database_tools_varchar2_tbl,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  nsg_ids dbms_cloud_oci_database_tools_varchar2_tbl,
  reverse_connection_configuration dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_private_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_private_endpoint_t (
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    display_name varchar2,
    description varchar2,
    id varchar2,
    endpoint_service_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vcn_id varchar2,
    subnet_id varchar2,
    private_endpoint_vnic_id varchar2,
    private_endpoint_ip varchar2,
    endpoint_fqdn varchar2,
    additional_fqdns dbms_cloud_oci_database_tools_varchar2_tbl,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    nsg_ids dbms_cloud_oci_database_tools_varchar2_tbl,
    reverse_connection_configuration dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the Database Tools private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_private_endpoint_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  locks dbms_cloud_oci_database_tools_resource_lock_tbl,
  display_name varchar2(32767),
  description varchar2(32767),
  id varchar2(32767),
  endpoint_service_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  private_endpoint_vnic_id varchar2(32767),
  private_endpoint_ip varchar2(32767),
  endpoint_fqdn varchar2(32767),
  additional_fqdns dbms_cloud_oci_database_tools_varchar2_tbl,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  nsg_ids dbms_cloud_oci_database_tools_varchar2_tbl,
  reverse_connection_configuration dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_private_endpoint_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_private_endpoint_summary_t (
    compartment_id varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    locks dbms_cloud_oci_database_tools_resource_lock_tbl,
    display_name varchar2,
    description varchar2,
    id varchar2,
    endpoint_service_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    vcn_id varchar2,
    subnet_id varchar2,
    private_endpoint_vnic_id varchar2,
    private_endpoint_ip varchar2,
    endpoint_fqdn varchar2,
    additional_fqdns dbms_cloud_oci_database_tools_varchar2_tbl,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    nsg_ids dbms_cloud_oci_database_tools_varchar2_tbl,
    reverse_connection_configuration dbms_cloud_oci_database_tools_database_tools_private_endpoint_reverse_connection_configuration_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_database_tools_private_endpoint_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_private_endpoint_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_database_tools_private_endpoint_summary_t) NOT PERSISTABLE;

List of `DatabaseToolsPrivateEndpointSummary` items.

Syntax

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

Fields

The user password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_user_password_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_user_password_t type.

Fields

The user password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_user_password_details_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_details_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_details_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_user_password_details_t type.

Fields

The user password.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_database_tools_user_password_summary_t (
  secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_summary_t (
    value_type varchar2,
    secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_database_tools_user_password_secret_id_summary_t is a subtype of the dbms_cloud_oci_database_tools_database_tools_user_password_summary_t type.

Fields

Error Information.

Syntax

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

Fields

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The update details for a Database Tools Generic JDBC database system connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_update_database_tools_connection_generic_jdbc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_update_database_tools_connection_details_t (
  url varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_generic_jdbc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_generic_jdbc_details_t (
    display_name varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    l_type varchar2,
    url varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_generic_jdbc_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_update_database_tools_connection_generic_jdbc_details_t is a subtype of the dbms_cloud_oci_database_tools_update_database_tools_connection_details_t type.

Fields

The related resource

Syntax

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

Fields

The update details for a Database Tools MySQL Server connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_update_database_tools_connection_my_sql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_update_database_tools_connection_details_t (
  related_resource dbms_cloud_oci_database_tools_update_database_tools_related_resource_my_sql_details_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_my_sql_details_t (
    display_name varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    l_type varchar2,
    related_resource dbms_cloud_oci_database_tools_update_database_tools_related_resource_my_sql_details_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_my_sql_details_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_update_database_tools_connection_my_sql_details_t is a subtype of the dbms_cloud_oci_database_tools_update_database_tools_connection_details_t type.

Fields

The related resource

Syntax

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

Fields

The update details for a Database Tools Oracle Database connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_update_database_tools_connection_oracle_database_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_update_database_tools_connection_details_t (
  related_resource dbms_cloud_oci_database_tools_update_database_tools_related_resource_details_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_details_tbl,
  private_endpoint_id varchar2(32767),
  proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_oracle_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_oracle_database_details_t (
    display_name varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    l_type varchar2,
    related_resource dbms_cloud_oci_database_tools_update_database_tools_related_resource_details_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_details_tbl,
    private_endpoint_id varchar2,
    proxy_client dbms_cloud_oci_database_tools_database_tools_connection_oracle_database_proxy_client_details_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_update_database_tools_connection_oracle_database_details_t is a subtype of the dbms_cloud_oci_database_tools_update_database_tools_connection_details_t type.

Fields

The related resource

Syntax

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

Fields

The update details for a Database Tools PostgreSQL Server connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_update_database_tools_connection_postgresql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_update_database_tools_connection_details_t (
  related_resource dbms_cloud_oci_database_tools_update_database_tools_related_resource_postgresql_details_t,
  connection_string varchar2(32767),
  user_name varchar2(32767),
  user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
  advanced_properties json_element_t,
  key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_tbl,
  private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_postgresql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_update_database_tools_connection_postgresql_details_t (
    display_name varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    l_type varchar2,
    related_resource dbms_cloud_oci_database_tools_update_database_tools_related_resource_postgresql_details_t,
    connection_string varchar2,
    user_name varchar2,
    user_password dbms_cloud_oci_database_tools_database_tools_user_password_details_t,
    advanced_properties json_element_t,
    key_stores dbms_cloud_oci_database_tools_database_tools_key_store_postgresql_details_tbl,
    private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_update_database_tools_connection_postgresql_details_t is a subtype of the dbms_cloud_oci_database_tools_update_database_tools_connection_details_t type.

Fields

The information to be updated.

Syntax

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

Fields

Connection validation details.

Syntax

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

Fields

Connection validation details for the MySQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_validate_database_tools_connection_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_details_t (
    l_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_details_t is a subtype of the dbms_cloud_oci_database_tools_validate_database_tools_connection_details_t type.

Connection validation result.

Syntax

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

Fields

Connection validaton result for the MySQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_result_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_validate_database_tools_connection_result_t (
  database_name varchar2(32767),
  database_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_result_t (
    l_type varchar2,
    code varchar2,
    message varchar2,
    cause varchar2,
    action varchar2,
    database_name varchar2,
    database_version varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_validate_database_tools_connection_my_sql_result_t is a subtype of the dbms_cloud_oci_database_tools_validate_database_tools_connection_result_t type.

Fields

Connection validation details for the Oracle Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_validate_database_tools_connection_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_details_t (
    l_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_details_t is a subtype of the dbms_cloud_oci_database_tools_validate_database_tools_connection_details_t type.

Connection validaton result for the Oracle Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_result_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_validate_database_tools_connection_result_t (
  database_name varchar2(32767),
  database_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_result_t (
    l_type varchar2,
    code varchar2,
    message varchar2,
    cause varchar2,
    action varchar2,
    database_name varchar2,
    database_version varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_validate_database_tools_connection_oracle_database_result_t is a subtype of the dbms_cloud_oci_database_tools_validate_database_tools_connection_result_t type.

Fields

Connection validation details for the PostgreSQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_validate_database_tools_connection_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_details_t (
    l_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_details_t is a subtype of the dbms_cloud_oci_database_tools_validate_database_tools_connection_details_t type.

Connection validaton result for the PostgreSQL Server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_result_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_tools_validate_database_tools_connection_result_t (
  database_name varchar2(32767),
  database_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_result_t (
    l_type varchar2,
    code varchar2,
    message varchar2,
    cause varchar2,
    action varchar2,
    database_name varchar2,
    database_version varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_tools_validate_database_tools_connection_postgresql_result_t is a subtype of the dbms_cloud_oci_database_tools_validate_database_tools_connection_result_t type.

Fields

A resource created or operated on by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_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),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    identifier varchar2,
    entity_uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_tools_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_work_request_resource_t) NOT PERSISTABLE;

An asynchronous work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_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_database_tools_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_database_tools_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_database_tools_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

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_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_database_tools_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_database_tools_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_database_tools_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_database_tools_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_work_request_summary_t) NOT PERSISTABLE;

List of `WorkRequestSummary` items.

Syntax

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

Fields

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_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_database_tools_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_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_database_tools_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_work_request_error_t) NOT PERSISTABLE;

List of WorkRequestError items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_work_request_error_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_database_tools_work_request_error_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_work_request_error_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_work_request_error_collection_t (
    items dbms_cloud_oci_database_tools_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_database_tools_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_database_tools_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_tools_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_database_tools_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_tools_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_tools_work_request_log_entry_t) NOT PERSISTABLE;

List of work request log items.

Syntax

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

Fields