UpdateDatabaseToolsSqlReportDetailsOracleDatabase

class oci.database_tools.models.UpdateDatabaseToolsSqlReportDetailsOracleDatabase(**kwargs)

Bases: UpdateDatabaseToolsSqlReportDetails

Database Tools SQL report information to be updated for a report of type ORACLE_DATABASE.

Attributes:

TYPE_ORACLE_DATABASE	A constant which can be used with the type property of a UpdateDatabaseToolsSqlReportDetails.
columns	Gets the columns of this UpdateDatabaseToolsSqlReportDetails.
defined_tags	Gets the defined_tags of this UpdateDatabaseToolsSqlReportDetails.
description	Gets the description of this UpdateDatabaseToolsSqlReportDetails.
display_name	Gets the display_name of this UpdateDatabaseToolsSqlReportDetails.
freeform_tags	Gets the freeform_tags of this UpdateDatabaseToolsSqlReportDetails.
instructions	Gets the instructions of this UpdateDatabaseToolsSqlReportDetails.
purpose	Gets the purpose of this UpdateDatabaseToolsSqlReportDetails.
source	Gets the source of this UpdateDatabaseToolsSqlReportDetails.
type	[Required] Gets the type of this UpdateDatabaseToolsSqlReportDetails.
variables	Gets the variables of this UpdateDatabaseToolsSqlReportDetails.

Methods:

__init__(**kwargs)	Initializes a new UpdateDatabaseToolsSqlReportDetailsOracleDatabase object with values from keyword arguments.
get_subtype(object_dictionary)	Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

TYPE_ORACLE_DATABASE = 'ORACLE_DATABASE'

A constant which can be used with the type property of a UpdateDatabaseToolsSqlReportDetails. This constant has a value of “ORACLE_DATABASE”

__init__(**kwargs)

Initializes a new UpdateDatabaseToolsSqlReportDetailsOracleDatabase object with values from keyword arguments. The default value of the type attribute of this class is ORACLE_DATABASE and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters

• display_name (str) – The value to assign to the display_name property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• type (str) – The value to assign to the type property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase. Allowed values for this property are: “ORACLE_DATABASE”

• source (str) – The value to assign to the source property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• description (str) – The value to assign to the description property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• purpose (str) – The value to assign to the purpose property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• instructions (str) – The value to assign to the instructions property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• variables (list[oci.database_tools.models.DatabaseToolsSqlReportVariable]) – The value to assign to the variables property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

• columns (list[oci.database_tools.models.DatabaseToolsSqlReportColumn]) – The value to assign to the columns property of this UpdateDatabaseToolsSqlReportDetailsOracleDatabase.

property columns

Gets the columns of this UpdateDatabaseToolsSqlReportDetails. Descriptive information on columns referenced in the Database Tools SQL Report source.

Returns

The columns of this UpdateDatabaseToolsSqlReportDetails.

Return type

list[oci.database_tools.models.DatabaseToolsSqlReportColumn]

property defined_tags

Gets the defined_tags of this UpdateDatabaseToolsSqlReportDetails. Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {“foo-namespace”: {“bar-key”: “value”}}

Returns

The defined_tags of this UpdateDatabaseToolsSqlReportDetails.

Return type

dict(str, dict(str, object))

property description

Gets the description of this UpdateDatabaseToolsSqlReportDetails. A description of the SQL report.

Returns

The description of this UpdateDatabaseToolsSqlReportDetails.

Return type

str

property display_name

Gets the display_name of this UpdateDatabaseToolsSqlReportDetails. A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.

Returns

The display_name of this UpdateDatabaseToolsSqlReportDetails.

Return type

str

property freeform_tags

Gets the freeform_tags of this UpdateDatabaseToolsSqlReportDetails. Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {“bar-key”: “value”}

Returns

The freeform_tags of this UpdateDatabaseToolsSqlReportDetails.

Return type

dict(str, str)

static get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

property instructions

Gets the instructions of this UpdateDatabaseToolsSqlReportDetails. Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.

Returns

The instructions of this UpdateDatabaseToolsSqlReportDetails.

Return type

str

property purpose

Gets the purpose of this UpdateDatabaseToolsSqlReportDetails. Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.

Returns

The purpose of this UpdateDatabaseToolsSqlReportDetails.

Return type

str

property source

Gets the source of this UpdateDatabaseToolsSqlReportDetails. SQL query executed to generate the report.

Returns

The source of this UpdateDatabaseToolsSqlReportDetails.

Return type

str

property type

[Required] Gets the type of this UpdateDatabaseToolsSqlReportDetails. The Database Tools SQL report type.

Allowed values for this property are: “ORACLE_DATABASE”

Returns

The type of this UpdateDatabaseToolsSqlReportDetails.

Return type

str

property variables

Gets the variables of this UpdateDatabaseToolsSqlReportDetails. Variables referenced in the Database Tools SQL Report source.

Returns

The variables of this UpdateDatabaseToolsSqlReportDetails.

Return type

list[oci.database_tools.models.DatabaseToolsSqlReportVariable]