Submit Multiple SQL statements to Oracle at a time using the JDBC Execute function

Although the efficiency of addbatch is good, sometimes you still need one execute to execute multiple SQL statements. However, if execute is executed directly (separated by semicolons), an exception may occur. You can perform the test in the following ways.

The idea is to wrap up multiple SQL statements and use begin and end as a PL/SQL block for execution.

Execute ("begin insert xxx; update xxx; Delete xxx; end;"); // note that there must be no less space after begin and a semicolon after end.

It's easy, right? Other databases are not tested. If you have such a need, you can execute it in a similar way.