Prepared statement in batch mode vs. FORALL in PL/SQL
A few days ago I had a nice discussion with one of our developers here in the office. The subject: […]
Misc
Code
Technology
The beauty of Java stored procedures
Since 8i you can write stored procedures also in Java. But what is the advantage of writing a procedure in
Misc
BULK COLLECT & FORALL vs. CURSOR & FOR LOOP
The more I read about BULK COLLECT and FORALL and their performance improvements, the more curious I got about how
Technology
JDBCs setMaxRows and the SELECT … FOR UPDATE clause
Today following question came up: Would the JDBC driver of Oracle regonize it, when you set the setMaxRows and perform