ExecuteSqlOutputResultDispositionTemplate¶
-
class
oci.database_tools_runtime.models.ExecuteSqlOutputResultDispositionTemplate(**kwargs)¶ Bases:
objectTemplate defining how the result of a command should be stored.
Attributes
STATEMENT_TYPE_DDLA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_DMLA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_IGNOREA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_JDBCA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_OTHERA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_PLSQLA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_QUERYA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_SESSION_CONTROLA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_SQLPLUSA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_SYSTEM_CONTROLA constant which can be used with the statement_type property of a ExecuteSqlOutputResultDispositionTemplate. STATEMENT_TYPE_TRANSACTION_CONTROLA 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.
-
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
-
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
-