Select from dual return 3 rows !

From: Frank B Hansen <frank4oraclel@xxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 8 Nov 2005 11:25:54 +0100 (CET)

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

Follow-Ups:

Re: Select from dual return 3 rows !
From: David Sharples

References:
- Re: Alter system switch logfile hang
  - From: NEW pop.tiscali.de

Other related posts:

» Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» Re: Select from dual return 3 rows !
» RE: Select from dual return 3 rows !