oracle10.1.0.4.0bug
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> select rownum from dual connect by rownum<=20;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
20 rows selected
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production
SQL> select rownum from dual connect by rownum<=20;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
ROWNUM
----------
21
21 rows selected
/*--------
該問題在10g release2 被解決了
http://www.itpub.net/showthread.php?s=&postid=5467062#post5467062
---------*/
10.1.0.3、10.1.0.5也是如此，但在10.2.0.1中是正確的
SQL> select rownum from dual connect by rownum <= 20;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
20 rows selected
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/756652/viewspace-242216/，如需轉載，請註明出處，否則將追究法律責任。