Select from dual return 3 rows ! 2005-11-08 - By Frank B Hansen
Hi List
On a 9.2.0.1.0 database I get the following result:
system@(protected)> select * from dual;
D
-
X
X
X
No matter what I select from dual, I get 3 rows. Anyone seen this behaviour ?
Thanks, Frank
<DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER
-LEFT: #1010ff 2px solid">
<BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT:
5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>Hi List</DIV>
<DIV> </DIV>
<DIV>On a 9.2.0.1.0 database I get the following result:</DIV>
<DIV> </DIV>
<DIV><A href="mailto:system@(protected)">system@(protected)</A>> select * from
dual;</DIV>
<DIV>D<BR>-<BR>X<BR>X<BR>X<BR></DIV>
<DIV>No matter what I select from dual, I get 3 rows. Anyone seen this
behaviour ?</DIV>
<DIV> </DIV>
<DIV>Thanks, Frank</DIV>
<DIV> </DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></DIV>
|
|
