ExecuteSqlInputStandardDetails¶

class oci.database_tools_runtime.models.ExecuteSqlInputStandardDetails(**kwargs)¶

Bases: oci.database_tools_runtime.models.execute_sql_input_details.ExecuteSqlInputDetails

Contains the details for the Standard SQL statements to execute on the database connection.

Attributes

`TYPE_BATCH`	str(object=’’) -> str
`TYPE_SCRIPT`	str(object=’’) -> str
`TYPE_STANDARD`	str(object=’’) -> str
`binds`	Gets the binds of this ExecuteSqlInputStandardDetails.
`limit`	Gets the limit of this ExecuteSqlInputStandardDetails.
`offset`	Gets the offset of this ExecuteSqlInputStandardDetails.
`properties`	Gets the properties of this ExecuteSqlInputStandardDetails.
`response_format`	Gets the response_format of this ExecuteSqlInputStandardDetails.
`statement_text`	[Required] Gets the statement_text of this ExecuteSqlInputStandardDetails.
`type`	[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'¶

TYPE_SCRIPT = 'SCRIPT'¶

TYPE_STANDARD = 'STANDARD'¶

__init__(**kwargs)¶

Initializes a new ExecuteSqlInputStandardDetails object with values from keyword arguments. The default value of the type attribute of this class is STANDARD 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 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.

binds¶

Gets the binds of this ExecuteSqlInputStandardDetails. Array of objects specifying the bind information.

Returns:	The binds of this ExecuteSqlInputStandardDetails.
Return type:	list[oci.database_tools_runtime.models.ExecuteSqlBind]

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.

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

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

properties¶

Gets the properties of this ExecuteSqlInputStandardDetails. Client properties returned as-is in the response

Returns:	The properties of this ExecuteSqlInputStandardDetails.
Return type:	object

response_format¶

Gets the response_format of this ExecuteSqlInputStandardDetails.

Returns:	The response_format of this ExecuteSqlInputStandardDetails.
Return type:	oci.database_tools_runtime.models.ExecuteSqlResponseFormat

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

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