From both a business and a data perspective, Alan Beaulieu illustrates how SQL alone can handle complex business logic that previously required the combination of PL/SQL. Alan is a coauthor of Mastering Oracle SQL.

By Alan Joch – Sophisticated database and analytical systems bring new efficiencies to life scientists.

The board of Oracle Corp. would consider paying a regular dividend if taxes on them were lifted, said Jeffrey Henley, chief financial officer of the database software giant.

By Ravinder Bhalla – Using the tip below, you can not only reinitialize the value of a variable after COMMIT at the backend or the SQL prompt, you can also execute specific functions or procedures only after COMMIT. It was tested on the Oracle 9i database, but it should be possible to run on 8i also

ActiveBase recently announced disaster recovery and performance enhancement solutions for Oracle databases.

Steven Feuerstein continues his exploration of new PL/SQL features in Oracle 9i with this article, cowritten with Bryn Llewellyn, and based on Bryn’s Oracle Corporation white paper originally presented at Oracle OpenWorld 2001 in San Francisco. Make the most of PL/SQL with Oracle PL/SQL Programming,

By Alorie Gilbert – Oracle intends to focus on its latest software at its upcoming AppsWorld conference, but many customers are hoping the database giant will spend some time explaining its plans for supporting an aging product.

By Fred Duran – This script generates a script that includes users in the table PRODUCT_USER_PROFILE table. In this way you can avoid entering them with SQL*PLUS. This tip is useful because DBAs can disable certain SQL and SQL*Plus commands on a user. It thus provides product-level security that sup

Database Admin, Reports Server, ODBC, Oracle Apps views from SQL*Plus, Performance Collection Services, Importing Java in Forms, Resource Management on an Oracle Database.

Create and deploy cross-platform, transaction-based applications on Oracle9i with XMLthe industry standard for describing data for e-business application integration and business-to-business exchanges.