Oracle-Connect

1、Oracle中Connect可以实现单条记录的递增操作。

select 'Chenbx' cal_man, '日程' cal_name,
       add_months(date '2009-10-1' + 22, rownum) end_date,
       add_months(date '2009-10-1', rownum) begin_date
  from dual
connect by rownum <= months_between(date '2019-10-1', date '2009-10-1');
引发以下测试与思考：
select * from dual connect by rownum <= 50;
select * from dual connect by rownum <= 90;
select * from dual connect by rownum <= 110;
select * from dual connect by rownum <= 1100;

结果：Oracle中Connect钻取的深度只能达到100层。