Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

This article explores the internals of materialized views and demonstrates how to precompute complex aggregates—having Oracle dynamically rewrite SQL to reference precomputed aggregate information.

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

The heart of any relational database management system is the system catalog that documents the database objects and system settings being used. The system catalog offers a wealth of information about ...

Oracle’s change in strategy to release a developer-first version of its new database is linked to the company’s plans to defend its market dominance and look at innovative ways to acquire new ...