Rittman Mead - Delivered Intelligence

Yesterday, I looked at collections, an evolution of PL/SQL tables that allows us to manipulate many variables at once, as a unit. Collections, coupled with two new features introduced with Oracle 8i, BULK_COLLECT and FORALL, can dramatically increase the performance of data manipulation code within PL/SQL. As a reminder, we were looking at a piece [...]

Slashdot reports a squabble between Sun and Eclipse: "CNET news is reporting on a potential spat between Sun and Eclipse: ‘Sun Microsystems has sent a letter to members of Eclipse, urging the increasingly influential open-source project to unify rather than fragment the Java-based development tool market.’ Although Sun’s letter says it wants interoperability, and a [...]

Yesterday I looked at some code written in Oracle 7-style PL/SQL, and compared it with what is considered best practice with Oracle 8i and 9i. The more up-to-date code generally runs around 3-5 times faster than the old style code, and, as part of understanding where the changes to PL/SQL have occurred, I’ve started off [...]

A couple of people recently asked the question on the OTN Discoverer Forum: "I am new to Discoverer tool as such. Therefore I have this question, pl pardon me if it very basic. When I use the desktop edition of Discoverer to make a connection to the Oracle db. One the database side, it creates [...]

Yesterday I looked at some code written in Oracle 7-style PL/SQL, and compared it with what is considered best practice with Oracle 8i and 9i. The more up-to-date code generally runs around 3-5 times faster than the old style code, and, as part of understanding where the changes to PL/SQL have occurred, I’ve started off [...]