Re: DataDictionary Dual?

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 5 Jan 1999 16:51:52 -0500
Message-ID: <8Uvk2.243$q_3.1071@news14.ispnews.com>

Hello Praveen:

Once you start playing with dual you'll see how useful it is. A lot of the Oracle documentation mentions that dual is one row and one column. However, there is nothing that prevents dual from holding more than one row. If you ever start getting odd results when selecting from dual, do a count(*) from dual to make sure no extra rows have crept in. Once when upgrading (from 7.1 to 7.2?) Oracle slipped a second row into dual and it took a long time for us to find out what was happening in some of our stored procedures.

Van

pgaur_at_cdotd.ernet.in wrote in message <76s5ot$9dt$2_at_nnrp1.dejanews.com>...
>Hi,
> While reading the Oracle 7 Server Concepts, I found a word, called DUAL.
>This I found in context of DataDictionary Objects. The only info about DUAL
I
>got is that The table named DUAL is a small table that Oracle and user
written
>programs can reference to guarantee a known result. This table has one
column
>and one row.
> This does not really gives any insight to what DUAL is.
>Can somebody help me in this aspect??
>Praveen Gaur
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 05 1999 - 15:51:52 CST