By Alan Joch – Take the next step beyond business intelligence. Tight integration of core BI technologies in the Oracle database kernel and Oracle9iAS gives you true business insight, in real time, from one place: the database.

Sean Hull has compiled this extensive collection of open source tools that can be used with Oracle databases. Sean is a coauthor of Oracle & Open Source.

Alert Discoverer users when new data arrives Q: How to setup alert of new data for Discoverer users?A: Call the following package from a table update trigger. Requires Oracle9i Database.

Self Test Software is Oracle’s only authorized practice test provider, and their practice tests map to the real exams, guaranteeing students complete coverage of the Oracle objectives as they prepare.

By D Busfield – Many people want to add a date to an output file name. This tip shows you how to name .dmp files with the date in the name. It works in NT and Unix, since it is an SQL solution, not an OS solution.

By Chris Lawson – In this paper, two experienced Oracle DBAs will introduce you to this exciting new feature. Since neither of us works for Oracle Corporation, we’d like to think this paper is balanced and objective. First we will introduce the DBMS_REDEFINITION package. Then we will give an overvie

by Bhagwan Mer – Description: I created these small snippets of dynamic PL/SQL programs for easy reference. I hope they are helpful.

In yet another strong show of support for the Linux operating system, market leaders Oracle, Dell Computer and Red Hat Software combined strengths to make the software more reliable, higher performance and easier to buy. For the first time, Dell will resell licenses for Oracle’s 9i database a

By Matthew A. Peretz – QUALCOMM Incorporated yesterday announced plans to work with Oracle Corporation to extend Oracle 9i Lite to support QUALCOMM’s Binary Runtime Environment for Wireless (BREW) platform, allowing companies to develop and deploy mobile enterprise applications for BREW-enabled devi

Learn how to retrieve rows set by set from an Oracle database without getting previously obtained rows in subsequent sets. Boris Milrud demonstrates how to use packages as holders for session-persistent data.