ExecuteSqlInputStandardDetails¶
- class oci.database_tools_runtime.models.ExecuteSqlInputStandardDetails(**kwargs)¶
Bases:
ExecuteSqlInputDetailsContains the details for the Standard SQL statements to execute on the database connection.
Attributes:
A constant which can be used with the type property of a ExecuteSqlInputDetails.
A constant which can be used with the type property of a ExecuteSqlInputDetails.
A constant which can be used with the type property of a ExecuteSqlInputDetails.
Gets the binds of this ExecuteSqlInputStandardDetails.
Gets the limit of this ExecuteSqlInputStandardDetails.
Gets the offset of this ExecuteSqlInputStandardDetails.
Gets the properties of this ExecuteSqlInputStandardDetails.
Gets the response_format of this ExecuteSqlInputStandardDetails.
[Required] Gets the statement_text of this ExecuteSqlInputStandardDetails.
[Required] Gets the type of this ExecuteSqlInputDetails.
Methods:
__init__(**kwargs)Initializes a new ExecuteSqlInputStandardDetails 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_BATCH = 'BATCH'¶
A constant which can be used with the type property of a ExecuteSqlInputDetails. This constant has a value of “BATCH”
- TYPE_SCRIPT = 'SCRIPT'¶
A constant which can be used with the type property of a ExecuteSqlInputDetails. This constant has a value of “SCRIPT”
- TYPE_STANDARD = 'STANDARD'¶
A constant which can be used with the type property of a ExecuteSqlInputDetails. This constant has a value of “STANDARD”
- __init__(**kwargs)¶
Initializes a new ExecuteSqlInputStandardDetails object with values from keyword arguments. The default value of the
typeattribute of this class isSTANDARDand 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 ExecuteSqlInputStandardDetails. Allowed values for this property are: “STANDARD”, “BATCH”, “SCRIPT”
statement_text (str) – The value to assign to the statement_text property of this ExecuteSqlInputStandardDetails.
limit (int) – The value to assign to the limit property of this ExecuteSqlInputStandardDetails.
offset (int) – The value to assign to the offset property of this ExecuteSqlInputStandardDetails.
binds (list[oci.database_tools_runtime.models.ExecuteSqlBind]) – The value to assign to the binds property of this ExecuteSqlInputStandardDetails.
response_format (oci.database_tools_runtime.models.ExecuteSqlResponseFormat) – The value to assign to the response_format property of this ExecuteSqlInputStandardDetails.
properties (object) – The value to assign to the properties property of this ExecuteSqlInputStandardDetails.
- property binds¶
Gets the binds of this ExecuteSqlInputStandardDetails. Array of objects specifying the bind information.
- Returns
The binds of this ExecuteSqlInputStandardDetails.
- Return type
- 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 limit¶
Gets the limit of this ExecuteSqlInputStandardDetails. The maximum number of rows to return from the query (-1 disables pagination).
- Returns
The limit of this ExecuteSqlInputStandardDetails.
- Return type
int
- property offset¶
Gets the offset of this ExecuteSqlInputStandardDetails. The first row to return in the result set.
- Returns
The offset of this ExecuteSqlInputStandardDetails.
- Return type
int
- property properties¶
Gets the properties of this ExecuteSqlInputStandardDetails. Client properties returned as-is in the response
- Returns
The properties of this ExecuteSqlInputStandardDetails.
- Return type
object
- property response_format¶
Gets the response_format of this ExecuteSqlInputStandardDetails.
- Returns
The response_format of this ExecuteSqlInputStandardDetails.
- Return type
- property statement_text¶
[Required] Gets the statement_text of this ExecuteSqlInputStandardDetails. Statements to execute (Can be more than one).
- Returns
The statement_text of this ExecuteSqlInputStandardDetails.
- Return type
str
- property type¶
[Required] Gets the type of this ExecuteSqlInputDetails. The Request type.
Allowed values for this property are: “STANDARD”, “BATCH”, “SCRIPT”
- Returns
The type of this ExecuteSqlInputDetails.
- Return type
str