How to execute multiple queries in oracle

334 Views Asked by At

Good morning.

I am making a function that connects to Oracle from JDBC and executes a query.

The number of query statements to be executed is about 50.

I looked for several examples, but most of them are examples that execute only one, and even this is only executed by putting the query in a variable.

I think it is impossible to put all 50 queries in a variable.

Among these, there is an option called allowMultiQueries=true in mysql, but it does not appear to be in oracle.

';', which means the end of the query syntax. Is there any other way to perform a multi-line query other than parsing based on?

0

There are 0 best solutions below