# 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;"
                       
   ```

   ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/use_case_toracle_multiplestatements.png)

   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;              
   ```