The integration service prepares the query for each input row and then runs the query. The integration service runs the query once and runs the same query for all the input rows.ĭynamic SQL query: The SQL query statement and the data can change. Static SQL query: The SQL query statement does not change, however you can pass parameters to the sql query. You can create the following types of SQL queries In query mode, the SQL transformation acts as an active transformation. The SQL transformation can output multiple rows when the query has a select statement.
You can pass parameters to the query to define dynamic queries. Query Mode: The SQL transformation executes a query that defined in the query editor.
#Oracle apex sql query transformation rule how to
We will see how to create an SQL transformation in script mode, query mode and passing the dynamic database connection with examples.Ĭreating SQL Transformation in Query Mode Connection type: You can pass database connection information or you can use a connection object.Database Type: The type of database that the SQL transformation connects to.You can configure it as passive transformation. Active/Passive: By default, SQL transformation is an active transformation.Mode: SQL transformation runs either in script mode or query mode.The following options can be used to configure an SQL transformation Transaction Control Statements (COMMIT, ROLLBACK).DATA Control Language Statements (GRANT, REVOKE).