构造序列
level为关键字,是从1开始的自增,connect by level 限定level的范围
select level from dual connect by level<=4;
select level from dual connect by level<13;
select date '2023-1-1' + level - 1 from dual connect by level<=365;
select lpad(level,2,0) from dual connect by level<13;
select SUBSTR('201312',1,4) from dual connect by level<13;
select SUBSTR('201312',1,4)||lpad(level,2,0) from dual connect by level<13;