The technical white paper, Database Architecture: Federated vs. Clustered, evaluates two different database architectures: the federated architecture, as represented by Microsoft SQL Server, and Oracle9i Real Application clusters. It also explains how to interpret and use benchmark results. (PDF)

By Karen Porter – Often I want to include a carriage return or other character into my SQL statement. Single tics are especially confusing due to breaking them on and off to be effective. I now use the CHR() function to write single tics into my SQL. If I forget what integer is required in the CHR()

by Boris Milrud – SQLJ is the evolving industry standard language that allows you to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms. Get the lowdown on connection contexts, iterators, executable statements, and host ex

This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP).

Real Application Clusters is one of the revolutionary features in Oracle 9i Database. Real Application Clusters is a breakthrough technology that provides many advantages for Online Transaction Processing (OLTP), Decision Support System (DSS), Online Analytic Processing (OLAP) and hybrid system type

By Timothy Dyck – For four weeks last month and early this month, eWEEK and sister publication PC Magazine carried out a comprehensive benchmark of the latest available versions of five server databases. These tests showed us on a level playing field which database performed best when used with a J

by Jason Price – This third column in my Learning SQLJ series explores how to add SQLJ statements to your Java programs that use embedded SQL Data Manipulation Language (DML) statements. DML statements may be used to retrieve and modify the contents of database tables. In this article, you will also

This tip comes from Eric T. Schmidt – Oracle 8.1.6 introduced 26 Analytic Functions that extend SQL in powerful and creative ways. With this new query formulation technique, it is easy to represent fine-grained control of complex queries without using complex sub queries, correlated queries, or PL/S

On July 31, 2002, the Oracle Certified Application Developer track for Oracle Developer Release 2 will be retired. All OCP Candidates following the Release 2 certification track will have until July 31, 2002 to complete the required core Oracle Developer exams in this track.

(Rohit Sinha) You may be sometimes required to create flat files on a weekly or monthly basis where the name of the file must be based on the date it was created. The following script will automatically add the date to the file name. This tip has been tested on Oracle versions 6, 7 & 8i. (R)