
OracleOperator
OracleExecutes sql code in a specific Oracle database.
Access Instructions
Install the Oracle provider package into your Airflow environment.
Import the module into your DAG file and instantiate it with your desired params.
Parameters
sqlthe sql code to be executed. Can receive a str representing a sql statement, a list of str (sql statements), or reference to a template file. Template reference are recognized by str ending in ‘.sql’ (templated)
oracle_conn_idThe Oracle connection id reference to a specific Oracle database.
parameters(optional, templated) the parameters to render the SQL query with.
autocommitif True, each command is automatically committed. (default value: False)
Documentation
Executes sql code in a specific Oracle database.