select trunc(sysdate - rownum + 1) day from dual CONNECT BY rownum <= 10
转载于:https://my.oschina.net/u/210131/blog/359830
select trunc(sysdate - rownum + 1) day from dual CONNECT BY rownum <= 10
转载于:https://my.oschina.net/u/210131/blog/359830