(Martin Zahn) If you’re going to realize the full potential of Oracle’s advanced replication facilities and simultaneously avoid the pitfalls, you need to understand the architecture on which they are based.

(Scott Stephens) It’s common to store username and password combinations in a database table for application-level security. This is a good practice because it avoids giving your actual database username and password combinations, which someone could use to access the tables and application code dir

(Andrei Cioroianu) Code reuse is a very good way to increase developer productivity and application maintainability. Instead of reinventing the wheel, you should always look for well-designed frameworks and customizable components. Application-specific code can also be reused across modules and

(Mark Vilrokx) In this series I am going to introduce you to a generic PL/SQL caching architecture. The goal is to give you an understanding of how you can store Table data in PL/SQL collections (“the cache”) and how to retrieve data from those same PL/SQL collections. The proposed architecture

(Lewis R Cunningham) In part 1 of this series I covered Associative Arrays and Record types. In Part 2, I covered Varrays and Nested Tables. Today I will be covering Sparse Arrays, Bulk Collect and the FORALL command.

(Jignesh Prajapati) This script provides information on active SQL.

(Lewis R Cunningham) The Oracle 10g database provides a rich set of features to secure and audit an application. Unfortunately, many applications treat security and audit as an after thought rather than a design goal. Security and audit, to be effective, must be an integral part of an application.

(Matthew Hart and Scott Jesse) When we talk about high availability, we must take into account more than just the basic question of “is the database up?” Much more than just that simple question is at stake. What really matters is the perceptions of the users. If the database is up but responsivene

(Alorie Gilbert) The updated products–PeopleSoft Enterprise Financial Management 8.9, PeopleSoft Enterprise Supplier Relationship Management 8.9 and PeopleSoft Enterprise Supply Chain Management 8.9–are part of a massive effort, called Project Fusion, to combine Oracle’s programs with those of its

(René Millman) A vulnerability researcher has attacked Oracle for failing to tackle a number of flaws in its software products.