RE: Select from dual return 3 rows !

From: Rudy Zung <Rudy.Zung_at_efi.com>
Date: Tue, 8 Nov 2005 13:10:23 -0500
Message-ID: <87F7A09D4DAF4C46A1EC7BFBF85047F3CFF1D5@pghexmb02.efi.internal>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Frank B Hansen
	Sent: Tuesday, November 08, 2005 5:26 AM
	To: ORACLE-L
	Cc: frank.hansen_at_kriminalforsorgen.dk
	Subject: Select from dual return 3 rows !
	
	

			Hi List
			 
			On a 9.2.0.1.0 database I get the following result:
			 
			system_at_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                                                    

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 08 2005 - 12:22:42 CST