Script Development / Oracle Database

The Oracle Database Connector primarily provides methods for operating Oracle databases.

Parameters for DFF.CONN(...) are as follows:

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

`.query(...)`

Executes an SQL statement, with the following parameters:

Parameter	Type	Required / Default	Description
`sql`	str	Required	SQL statement, which can include parameter placeholders. `?` indicates parameters to be escaped; `??` indicates parameters not to be escaped
`sql_params`	list	`None`	SQL parameters

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

Dynamic SQL Statements

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

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

For more details, please refer to the Script Development / SQL Construction DFF.SQL