摘要:
今天看到qq群里有人在用sql写日历,自己也写了个,作下记录;create or replace procedure get_Calender(choosedate in date) is/* 功能: 根据入参日期打印当月的日历(星期天在第一天)*/ cursor cur_Calender is select nvl(max(decode(wk, 1, calender, null)), '--') as "SUN", nvl(max(decode(wk, 2, calender, null)), '--') as "MON&quo 阅读全文