오라클(Oracle)로 캘린더 만들기
1. SQL : SELECT SUM(DECODE(a.day_num, '1', a.day_cnt, '')) "sunDay", SUM(DECODE(a.day_num, '2', a.day_cnt, '')) "monDay", SUM(DECODE(a.day_num, '3', a.day_cnt, '')) "tueDay", SUM(DECODE(a.day_num, '4', a.day_cnt, '')) "wedDay", SUM(DECODE(a.day_num, '5', a.day_cnt, '')) "thuDay", SUM(DECODE(a.day_num, '6', a.day_cnt, '')) "friDay", SUM(DECODE(a.day_num, '7', a.day_cnt, '')) "satDay" FROM (SELECT..
2014. 12. 2.