(Jeffrey R. McCormick) The DUAL table is one of the first things we learn as Oracle professionals. It is created by default as a single row table, understood by the optimizer and available to everyone for selection. We typically use this table to select the name of the current user, ping the databas

(Ron Hardman) If your company is like most, data—some meant to be shared and some not—is stored in multiple locations. Those locations may include –File servers –E-mail messages and attachments –ERP modules –An intranet –Configuration management repositories –Multiple databases

(Lewis R Cunningham) I recently wrote about NVL2. A function much like NVL2 is coalesce.

This one-day event is designed for Oracle professionals who have cross-platform responsibilities or need to transfer their skill sets to SQL Server, and for IT managers seeking database computing environment improvements for their organizations. We are bringing Oracle professionals together to learn

(Jayaram Krishnaswamy) Visual Basic 6.0 is still a preferred programming option for many developers. With Oracle 10G XE being adopted by many because of its great number of virtues, connecting to Oracle with VB6 is bound to become very frequent. This tutorial shows how easy it is to display Tables,

(Jayaram Krishnaswamy) If you’re a DBA, one of your basic tasks involves managing users: dropping, adding, and changing permissions. Even if you aren’t a DBA, if you use a database, you may find it helpful to know the tasks that a DBA performs. This article explains the basics for how to perform the

(Bob Watkins) Oracle 9i introduced a flashback query feature that displays query results as of a prior point in time. However, the table itself was not modified. Oracle 10g extended the flashback feature to flash back a table permanently. Now Oracle 10g Release 2 makes this process easier with the a

(Kailash Awati and Arati Apte) This article is introduces Oracle’s CUBE and ROLLUP extensions to the GROUP BY clause. The schema and sample data population scripts that accompany the discussion can be accessed here.

(Lewis R Cunningham) A BOOLEAN datatype is a native PL/SQL type that lets you signify a TRUE or FALSE condition. A BOOLEAN is NULL until explicitly assigned a value.

(Greg Williams) I have to parse an image from XML. The image is in base64 encoded form. I have to parse the image, convert it to binary and load it in a blob in an Oracle database. (R)