Using Bulk Binds And FORALL

Saturday, January 31st, 2004 by Mark Rittman

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 of code that implemented
collections, BULK […]

Slashdot On The Squabble Between Sun And Eclipse

Saturday, January 31st, 2004 by Mark Rittman

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 ‘broad base’ for java tools, it
then insists […]

Improving PL/SQL Performance By Using Collections

Friday, January 30th, 2004 by Mark Rittman

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 […]

Joe Luedke On BI Barriers For Small & Medium Size Businesses

Friday, January 30th, 2004 by Mark Rittman

"While much has been talked and written about regarding the return on
investment of business intelligence initiatives, little has been discussed
concerning the barrier to entry that many small and medium-size businesses (SMB)
face when staring straight in the eyes of a business problem that requires a BI
solution." writes Joe
Luedtke in this DMReview.com article entitled "BI
for the Masses: […]

Why Does Discoverer Create Two Dedicated Connections?

Friday, January 30th, 2004 by Mark Rittman

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 2 dedicated connection for that […]

Website Design & Build: tymedia.co.uk