RE: Select from dual return 3 rows !
- From: "Rudy Zung" <Rudy.Zung@xxxxxxx>
- To: <frank4oraclel@xxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Nov 2005 13:10:23 -0500
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:
