(Andy Campbell) Here is a quick tip that I’ve found useful for enhancing my SQL*Plus reports and scripts …

(John Charles Olamendy) This article is intended to illustrate one of the most common business scenarios such as displaying data from Oracle database on a form in a Windows application using DataSet objects and .NET Framework Data Provider for Oracle. I want to attend some questions about this topic

(Frank Zhou) The following two SQL patterns can be used to assign the same number to different groups that contain the identical set of data.

(Elisa Gabbert) As a way of staking its leadership in the area, Oracle announced yesterday that over 100 commercial and open source applications are using its semantic Web technology. (R)

(Jim Czuprynski) With Oracle Secure Backup, Oracle now offers the capability to insure that all Recovery Manager (RMAN) backups are created and maintained in a secure fashion, all without the need for a potentially expensive and cumbersome media management layer (MML). This article – the final one i

(Bob Watkins) SQL*Plus has traditionally been thought of as a plain text SQL query tool. But since Oracle 8i, it has also had the capability to render its output using HTML.

(Rudy Limeback) How to find the cumulative sum without using an analytical function? (R)

(Steve Callan) How and when do alerts or informational messages about what’s taking place inside your database make their way out to you, the DBA par excellence? There are several ways, some free and some hand-crafted, to expose alerts and messages. Let’s face it, as the Oracle RDBMS engine becomes

(Andrew Fraser) In versions 10g, plan_table exists as a public synonym of the global temporary table sys.plan_table$. That is all created automatically at database create time and when a database is upgraded to 10g (creation is in catplan.sql, which is called from catproc.sql and u*.sql scripts in $

(Lewis Cunningham) I’ll start off by saying that I believe implicit conversion to be bad. Badder. Evil. A serious no-no!