Executing multiple SQL statements with one tOracleRow component
This article explains how to execute multiple SQL statements using a single tOracleRow component rather than multiple components.
Procedure
-
Double-click tOracleRow and enter the below statements in the Query field:
"begin update table1 set name='Shong' where id=2; update table1 set name='Patrick' where id=3; delete from table1 where id=4; commit; end;"
Information noteNote: The above example has only DML statements. If the group of SQL statements contains DDL statements, type execute immediate followed by the DDL statement. For example:begin update table1 set name='Shong' where id=2; execute immediate 'drop table t3'; commit; end;