Script Development / Oracle Database

The Oracle Database connector operation object primarily provides methods for operating Oracle databases.

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

Parameter	Type	Required / Default	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specify database

`.query(...)`

Execute SQL statement, parameters are as follows:

Parameter	Type	Required / Default	Description
`sql`	str	Required	SQL statement, which can contain 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)

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

Such as WHERE IN (...) with an uncertain number of values, or INSERT INTO ... VALUES ... for batch data insertion, etc.