|
myth8860 发表于 2013-8-14 12:48 ![]()
呵呵,这是个伪表,没啥意义
connect by 有个bug
SQL>select level l from dual connect by level<=4;
L
-----------
1
2
3
4
已用时间:2.045(毫秒). 执行号:497.
SQL>select level l,rownum rn from dual connect by rownum<=4;
L RN
----------- --------------------
1 1
2 2
3 3
4 4
5 5
已用时间:2.156(毫秒). 执行号:498.
oracle
SQL> select level l,rownum rn from dual connect by rownum<=4;
L RN
---------- ----------
1 1
2 2
3 3
4 4
|
|