Skip to main content Skip to complementary content

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

  1. Drop a tOracleRow component from the Palette to the design workspace.
  2. 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;              

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!