RE: Select from dual return 3 rows !

DUAL, when you really come down to it, is really just a table into which
Oracle defaults with just a single record. However, because it is just a
simple table, additional records can be inserted into it, as you have just
discovered.
 
Log in as SYStem and delete all but one records from dual.
 
Because there is no guarantee that DUAL will always return exactly one
record, I tend to select from USER_USERS when I really want to have exactly
one record coming back to me.
 
...Rudy
 

        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Frank B Hansen
        Sent: Tuesday, November 08, 2005 5:26 AM
        To: ORACLE-L
        Cc: frank.hansen@xxxxxxxxxxxxxxxxxxxx
        Subject: Select from dual return 3 rows !
        
        

                        Hi List
                         
                        On a 9.2.0.1.0 database I get the following result:
                         
                        system@HCRD9397> select * from dual;
                        D
                        -
                        X
                        X
                        X
                        
                        No matter what I select from dual, I get 3 rows.
Anyone seen this behaviour ?
                         
                        Thanks, Frank

Other related posts: