ExecuteSqlInputStandardDetails

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

Bases: ExecuteSqlInputDetails

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

Attributes:

TYPE_BATCH

A constant which can be used with the type property of a ExecuteSqlInputDetails.

TYPE_SCRIPT

A constant which can be used with the type property of a ExecuteSqlInputDetails.

TYPE_STANDARD

A constant which can be used with the type property of a ExecuteSqlInputDetails.

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'

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 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.

property 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.

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

oci.database_tools_runtime.models.ExecuteSqlResponseFormat

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