ExecuteSqlOutputResultDispositionTemplate

class oci.database_tools_runtime.models.ExecuteSqlOutputResultDispositionTemplate(**kwargs)

Bases: object

Template defining how the result of a command should be stored.

Attributes:

STATEMENT_TYPE_DDL

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_DML

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_IGNORE

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_JDBC

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_OTHER

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_PLSQL

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_QUERY

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_SESSION_CONTROL

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_SQLPLUS

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_SYSTEM_CONTROL

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

STATEMENT_TYPE_TRANSACTION_CONTROL

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate.

object_template

[Required] Gets the object_template of this ExecuteSqlOutputResultDispositionTemplate.

statement_type

[Required] Gets the statement_type of this ExecuteSqlOutputResultDispositionTemplate.

Methods:

__init__(**kwargs)

Initializes a new ExecuteSqlOutputResultDispositionTemplate object with values from keyword arguments.

STATEMENT_TYPE_DDL = 'DDL'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “DDL”

STATEMENT_TYPE_DML = 'DML'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “DML”

STATEMENT_TYPE_IGNORE = 'IGNORE'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “IGNORE”

STATEMENT_TYPE_JDBC = 'JDBC'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “JDBC”

STATEMENT_TYPE_OTHER = 'OTHER'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “OTHER”

STATEMENT_TYPE_PLSQL = 'PLSQL'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “PLSQL”

STATEMENT_TYPE_QUERY = 'QUERY'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “QUERY”

STATEMENT_TYPE_SESSION_CONTROL = 'SESSION_CONTROL'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “SESSION_CONTROL”

STATEMENT_TYPE_SQLPLUS = 'SQLPLUS'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “SQLPLUS”

STATEMENT_TYPE_SYSTEM_CONTROL = 'SYSTEM_CONTROL'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “SYSTEM_CONTROL”

STATEMENT_TYPE_TRANSACTION_CONTROL = 'TRANSACTION_CONTROL'

A constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. This constant has a value of “TRANSACTION_CONTROL”

__init__(**kwargs)

Initializes a new ExecuteSqlOutputResultDispositionTemplate object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • statement_type (str) – The value to assign to the statement_type property of this ExecuteSqlOutputResultDispositionTemplate. Allowed values for this property are: “QUERY”, “DML”, “DDL”, “PLSQL”, “SQLPLUS”, “IGNORE”, “TRANSACTION_CONTROL”, “SESSION_CONTROL”, “SYSTEM_CONTROL”, “JDBC”, “OTHER”

  • object_template (oci.database_tools_runtime.models.ExecuteSqlOutputDispositionDetails) – The value to assign to the object_template property of this ExecuteSqlOutputResultDispositionTemplate.

property object_template

[Required] Gets the object_template of this ExecuteSqlOutputResultDispositionTemplate.

Returns

The object_template of this ExecuteSqlOutputResultDispositionTemplate.

Return type

oci.database_tools_runtime.models.ExecuteSqlOutputDispositionDetails

property statement_type

[Required] Gets the statement_type of this ExecuteSqlOutputResultDispositionTemplate. Commands matching this statement type will use this result disposition.

Allowed values for this property are: “QUERY”, “DML”, “DDL”, “PLSQL”, “SQLPLUS”, “IGNORE”, “TRANSACTION_CONTROL”, “SESSION_CONTROL”, “SYSTEM_CONTROL”, “JDBC”, “OTHER”

Returns

The statement_type of this ExecuteSqlOutputResultDispositionTemplate.

Return type

str