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.

Making object-to-relational maps happen. By Rich Seeley; May 5, 2003; The table views of the relational world and the object views of Java programming often clash as developers seek to build working ...

CREATE OR REPLACE VIEW emp_dept_view (empno, ename, job, edept) AS SELECT empno, ename, job, MAKE_REF(dept_ext_view, deptno) FROM employee; Below are my concerns: MAKE_REF is built-in function in ...

Oracle Objects for OLE (OO4O) is a set of software layers designed to provide access to an Oracle database from Microsoft COM Automation and ActiveX compatible languages such as Visual Basic ...