摘要: SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2014-10', 'yyyy-MM'), ROWNUM - 1), 'yyyy-MM') as monthlist FROM DUALCONNECT BY ROWNUM <= months_between(to_date('20 阅读全文
posted @ 2019-05-20 14:26 冬天不眠 阅读(725) 评论(0) 推荐(0) 编辑
摘要: create or replaceFUNCTION "SF_SPLIT_ACCOUNT_ID_LIST" ( account_id_list IN VARCHAR2)RETURN VARCHAR2 ASv_account_id_list VARCHAR2(5000); BEGIN WITH ACCT 阅读全文
posted @ 2019-05-20 14:07 冬天不眠 阅读(1492) 评论(0) 推荐(0) 编辑
摘要: 阅读全文
posted @ 2019-05-20 09:49 冬天不眠 阅读(4553) 评论(1) 推荐(0) 编辑