select trunc(sysdate-rownum*365,'YYYY') from dual connect by rownum<65
connect by 后面不接连接条件时,数据可连接自身,无限下去,rownum控制它的行数,
也可以写成select trunc(sysdate-rownum*365,'YYYY') from dual connect by level<65
connect by 后面接的条件如果为true,比如接1=1,则可以生成无限多行
select trunc(sysdate-rownum*365,'YYYY') from dual connect by rownum<65
connect by 后面不接连接条件时,数据可连接自身,无限下去,rownum控制它的行数,
也可以写成select trunc(sysdate-rownum*365,'YYYY') from dual connect by level<65
connect by 后面接的条件如果为true,比如接1=1,则可以生成无限多行