CreateDatabaseToolsSqlReportOracleDatabaseDetails¶

class oci.database_tools.models.CreateDatabaseToolsSqlReportOracleDatabaseDetails(**kwargs)¶

Bases: oci.database_tools.models.create_database_tools_sql_report_details.CreateDatabaseToolsSqlReportDetails

Details for the new Database Tools SQL report.

Attributes

`TYPE_ORACLE_DATABASE`	str(object=’’) -> str
`columns`	Gets the columns of this CreateDatabaseToolsSqlReportDetails.
`compartment_id`	[Required] Gets the compartment_id of this CreateDatabaseToolsSqlReportDetails.
`defined_tags`	Gets the defined_tags of this CreateDatabaseToolsSqlReportDetails.
`description`	Gets the description of this CreateDatabaseToolsSqlReportDetails.
`display_name`	[Required] Gets the display_name of this CreateDatabaseToolsSqlReportDetails.
`freeform_tags`	Gets the freeform_tags of this CreateDatabaseToolsSqlReportDetails.
`instructions`	Gets the instructions of this CreateDatabaseToolsSqlReportDetails.
`locks`	Gets the locks of this CreateDatabaseToolsSqlReportDetails.
`purpose`	Gets the purpose of this CreateDatabaseToolsSqlReportDetails.
`source`	[Required] Gets the source of this CreateDatabaseToolsSqlReportDetails.
`type`	[Required] Gets the type of this CreateDatabaseToolsSqlReportDetails.
`variables`	Gets the variables of this CreateDatabaseToolsSqlReportDetails.

Methods

`__init__`(**kwargs)	Initializes a new CreateDatabaseToolsSqlReportOracleDatabaseDetails 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'¶

__init__(**kwargs)¶

Initializes a new CreateDatabaseToolsSqlReportOracleDatabaseDetails 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:

type (str) – The value to assign to the type property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails. Allowed values for this property are: “ORACLE_DATABASE”
compartment_id (str) – The value to assign to the compartment_id property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
display_name (str) – The value to assign to the display_name property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
source (str) – The value to assign to the source property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
description (str) – The value to assign to the description property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
purpose (str) – The value to assign to the purpose property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
instructions (str) – The value to assign to the instructions property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
variables (list[oci.database_tools.models.DatabaseToolsSqlReportVariable]) – The value to assign to the variables property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
columns (list[oci.database_tools.models.DatabaseToolsSqlReportColumn]) – The value to assign to the columns property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.
locks (list[oci.database_tools.models.ResourceLock]) – The value to assign to the locks property of this CreateDatabaseToolsSqlReportOracleDatabaseDetails.

columns¶

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

Returns:	The columns of this CreateDatabaseToolsSqlReportDetails.
Return type:	list[oci.database_tools.models.DatabaseToolsSqlReportColumn]

compartment_id¶

[Required] Gets the compartment_id of this CreateDatabaseToolsSqlReportDetails. The OCID of the compartment containing the Database Tools SQL report.

Returns:	The compartment_id of this CreateDatabaseToolsSqlReportDetails.
Return type:	str

defined_tags¶

Gets the defined_tags of this CreateDatabaseToolsSqlReportDetails. 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 CreateDatabaseToolsSqlReportDetails.
Return type:	dict(str, dict(str, object))

description¶

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

Returns:	The description of this CreateDatabaseToolsSqlReportDetails.
Return type:	str

display_name¶

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

Returns:	The display_name of this CreateDatabaseToolsSqlReportDetails.
Return type:	str

freeform_tags¶

Gets the freeform_tags of this CreateDatabaseToolsSqlReportDetails. 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 CreateDatabaseToolsSqlReportDetails.
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.

instructions¶

Gets the instructions of this CreateDatabaseToolsSqlReportDetails. 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 CreateDatabaseToolsSqlReportDetails.
Return type:	str

locks¶

Gets the locks of this CreateDatabaseToolsSqlReportDetails. Locks associated with this resource.

Returns:	The locks of this CreateDatabaseToolsSqlReportDetails.
Return type:	list[oci.database_tools.models.ResourceLock]

purpose¶

Gets the purpose of this CreateDatabaseToolsSqlReportDetails. 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 CreateDatabaseToolsSqlReportDetails.
Return type:	str

source¶

[Required] Gets the source of this CreateDatabaseToolsSqlReportDetails. SQL query executed to generate the report.

Returns:	The source of this CreateDatabaseToolsSqlReportDetails.
Return type:	str

type¶

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

Allowed values for this property are: “ORACLE_DATABASE”

Returns:	The type of this CreateDatabaseToolsSqlReportDetails.
Return type:	str

variables¶

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

Returns:	The variables of this CreateDatabaseToolsSqlReportDetails.
Return type:	list[oci.database_tools.models.DatabaseToolsSqlReportVariable]