(Craig Shallahamer) Sometimes I get things I really don’t need. Like this really cool GPS I got for my birthday last month. It does do some useful stuff like tell me where I am on this earth, and it keeps me from getting lost while backpacking or driving to a customer site. But the really cool thing

This IBM Redbook will help you install, tailor and configure the new Oracle Database 10g on z/OS. It describes experiences with the new installation process, and will be especially useful for anyone unfamiliar with the Oracle Universal Installer and IBM UNIX System Services who is installing Oracle

(Shankar Govindan) When we plan to move a large database or a heavily used OLTP database to a cluster setup, to get enough mileage from the horizontal scaling of 9i RAC, we normally have lots of questions on how we are going to handle various database maintenance that are traditionally done, how we

When a SQL statement is executed, the database must convert the query into an execution plan and choose the best way to retrieve the data. For Oracle, each SQL query has many choices for execution plans: –Including which index to use to retrieve table row. –What order in which to join mult

(James Koopmann) Wouldn’t it be nice if you didn’t have to install the full Oracle client software just to get connectivity to an Oracle instance? Well, it is now reality with Oracle’s new Instant Client software offering.

A common advanced computer science problem can be described under the heading of “directed graphs.” A directed graph is a finite set of nodes connected by a set of vectors or edges. For example, a node can be imagined as a “city” and each vector as a “flight” between two cities. (R)

(Kuassi Mensah) The new generation of Java Database Connectivity (JDBC) drivers in Oracle Database 10g can make a big difference in how well your Java applications perform. Whether you’re working with Java 2 Standard Edition applications, Servlets, JavaServer Pages, stateful session beans, Enter

(Mike Lehmann) Often the first reaction developers have when they hear about BPEL is a question: Why do I need a standard to solve something that could likely be done programmatically? Obviously there is nothing forcing a developer to use BPEL, and a developer can create a simple business process th

(Jeff Maresh) Often times in life, we make decisions based upon the Law of Primacy. This law implies that what you learned first is what you recall first. This occurs even after new concepts appear that contradict what was originally learned. The adage, “old habits die hard” is the popular version o

(Deepak Vohra) PL/SQL is commonly used to create a connection to a database, generate tables, retrieve result sets, and perform updates. The result set from a SQL query with PL/SQL, of course, is a text table. With the increasing use of XML in J2EE applications, many J2EE developers now require