The new edition of this must-have pocket reference boils down the most vital information from Oracle PL/SQL Programming, the bestseller that many consider “the Bible” for PL/SQL development.

By Prince Kumar – The following script finds the tablespaces that can extent to a maximum of "ExtLimit". In this case, I didn’t want any files to be more than 2 GB so I set MAXSIZE to 2 GB. Also, I did not include temp files in this script.

By Lisa Vaas – Oracle Corp. and Unisys Corp. have been tapped by a Homeland Security agency to construct a single online spot to report security incidents relating to airlines and other transportation systems and for travelers to check on situations in flux.

by Kirill Richine – The script below provides a mechanism to depth-first traverse and list the contents of these trees. The first block takes a grantee as argument and lists the grant tree for it. The second block takes a privilege as argument and lists the grantee tree for it.

Steven Feuerstein and Bryn Llewellyn explore the extended flexibility of the collection syntax, storage, and access in Oracle 9i Release 2, which makes it possible to write simpler, more efficient code. Steven is a coauthor of Oracle PL/SQL Programming, 3rd Edition.

Oracle and Dell cosied up to one another in New York this week to pitch their deal to sell clustered server systems to enteprise customers using an open standards philosophy. Dell’s strategy is to sell servers primarily using two to four processors that can be combined, or clustered, to boost

By Stacy Cowley – At a gathering here Tuesday of current and potential Oracle ISV (independent software vendor) partners, Oracle Chairman and Chief Executive Officer Larry Ellison extolled the virtues of Linux and predicted that the open-source operating system will soon decimate Microsoft in the ba

By John G. Spooner – Dell will offer new computing clusters based on its servers, Oracle’s 9i Database software and the Linux operating system. The two companies will also work together to create a new suite of professional services related to clusters. The new agreement, which expands a five-year p

Oracle provides several methods for reducing the time spent parsing Oracle SQL statements, which can cause a drag on performance when executing complex queries with a large number of possible execution plans.

By Paul Krill – Oracle will stress frameworks and the need to make Java programming accessible to more developers in a release of its JDeveloper developer environment that the company will focus on in June.