摘要: 今天看到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 阅读全文
posted @ 2011-09-20 14:02 jianggc.zj 阅读(1976) 评论(0) 推荐(1) 编辑