(Bradley D. Brown) Have you been wondering how you might use Java stored procedures instead of Oracle’s native PL/SQL stored procedures? This article discusses the pros and cons of Java stored procedures, guidelines on how to build them, the separation line for the database vs. App Server Java, perf

by Zlatko Sirotic – How do you determine how deep some foreign key constraints are? For example, EMP has a foreign key on DEPT, DEPT has a foreign key on DEPT_TYPE … With following solution, you don’t need to use a temporary table to determine the depth of foreign keys:

By Joshua Greenbaum – One of the great migrations of the software industry is about the begin anew. It’s the migration of Oracle’s time and energy back into a key market that the company hasn’t paid much attention to of late.

By Rich Niemiec – If you could choose just two Oracle utilities to find and monitor performance problems in your Oracle9i Database system, those two utilities would be Oracle Enterprise Manager (now available in Release 4.0) and Statspack. As of Oracle8i Release 8.1.6, the Statspack utility replaced

By Robert Lemos – Red Hat and Oracle plan to announce that the companies have teamed to get Linux evaluated under the Common Criteria, a certification that could open doors for the broader use of open-source software by government agencies.

Oracle and Hitachi Data Systems announced on Wednesday plans to expand the collaboration between the server and software maker and the storage-system vendor.

By Amy Newman – The application server market is an ever-evolving and highly competitive space. Vendors, particularly the high-profile ones, are forever scrambling to gain — and keep — market share.With new releases of WebSphere and Oracle Application Server slated to come out in the next

By Murali Krishna B – DECODE is a very powerful tool that can make SQL very efficient or very dense and nonintutive. Using the example below, you can easily track which user is doing what.

Find out how the authors of this Oracle opus pared down 13,000 pages of documentation to provide users with 80 percent of the useful information in 20 percent of the space. If you’re an Oracle user, you’ll want to check out, Oracle in a Nutshell.

The following two scripts provide a way for searching a text within a trigger body (LONG datatype column):