Accounting Calendar template

SELECT INITCAP (TO_CHAR (TO_DATE (&year || '-' || LPAD (ROWNUM, 2, '0'), 'yyyy-mm'), 'MON', 'NLS_DATE_LANGUAGE=AMERICAN')) prefix , 'Month' TYPE , TO_CHAR (&year) year , TO_CHAR (TO_DATE (&year || '-...
posted @ 2018-06-24 23:31  全威儒  阅读(417)  评论(0编辑  收藏  举报