Oracle按固定次数递归生成日期[@more@]select rownum,add_months(add_months(to_date('2010-01-01','yyyy-mm-dd'),-1),rownum) mon
from dual connect by level
from dual connect by level
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25261409/viewspace-1058827/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25261409/viewspace-1058827/