Select from dual return 3 rows !

From: Frank B Hansen <frank4oraclel_at_yahoo.dk>
Date: Tue, 8 Nov 2005 11:25:54 +0100 (CET)
Message-ID: <20051108102554.93612.qmail@web86904.mail.ukl.yahoo.com>

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 - 04:27:58 CST

This message: [ Message body ]
Next message: David Sharples: "Re: Select from dual return 3 rows !"
Previous message: NEW pop.tiscali.de: "Re: Alter system switch logfile hang"
In reply to: NEW pop.tiscali.de: "Re: Alter system switch logfile hang"
Next in thread: David Sharples: "Re: Select from dual return 3 rows !"
Reply: David Sharples: "Re: Select from dual return 3 rows !"
Maybe reply: Rudy Zung: "RE: Select from dual return 3 rows !"
Maybe reply: Hollis, Les: "RE: Select from dual return 3 rows !"
Maybe reply: Dougie McGibbon: "RE: Select from dual return 3 rows !"
Maybe reply: Igor Neyman: "RE: Select from dual return 3 rows !"
Maybe reply: Rudy Zung: "RE: Select from dual return 3 rows !"
Maybe reply: Norman Dunbar: "Re: Select from dual return 3 rows !"
Maybe reply: Norman Dunbar: "Re: Select from dual return 3 rows !"
Maybe reply: Jacques Kilchoer: "RE: Select from dual return 3 rows !"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US