Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--' insert into mytestvalues (:1)'--and binds the values on each iteration.

Now, using hibernate (it's actually a spring-boot 3.3 application), I am trying to insert data into the table and the (generated) prepared statement throws a Systax Errror.