Oracle Connect by 用法解析

简答的例子：

<p></p><p></p><pre name="code" class="sql"> select  level   from  dual  connect  by  1  =  1

 SELECT TRUNC(SYSDATE,'mm')+ (LEVEL - 1) AS DAYS                      FROM DUAL                    CONNECT BY TRUNC(SYSDATE,'mm') +                               LEVEL - 1 < TRUNC(ADD_MONTHS(SYSDATE,1),'mm')

 select  level   from  dual  connect  by  1  =  1