Script Development / Oracle DATABASE

The Oracle DATABASE connector operation object primarily provides methods for operating on the Oracle DATABASE.

DFF.CONN(...) parameters are as follows:

Parameter	Type	Required / Default Value	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specifies DATABASE

`.query(...)`

Executes an SQL statement, with the following parameters:

Parameter	Type	Required / Default Value	Description
`sql`	str	Required	SQL statement that may include parameter placeholders. `?` indicates a parameter that needs escaping; `??` indicates a parameter that does not need escaping.
`sql_params`	list	`None`	SQL parameters

Example
sql = 'SELECT * FROM ?? WHERE seq > ?'
sql_params = ['demo', 1]
result = db.query(sql, sql_params=sql_params)

Both query(...) and non_query(...) use DFF.SQL(...) internally to construct SQL statements and support building complex dynamic SQL statements.

For example, handling an uncertain number of values in WHERE IN (...), or performing bulk data inserts with INSERT INTO ... VALUES ....