Mr zhao

摘要： BEGINDELETE FROM SYSROLEOPENR WHERE ROLEID = 2;INSERT INTO SYSROLEOPENR (PKID, ROLEID, OPERID) SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL, '2' ROLEID, OPERID FROM SYSMODULEOPER WHERE OPERCODE = '300090010';INSERT INTO SYSROLEOPENR (PKID, ROLEID, OPERID) SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL 阅读全文

摘要： oracle日期相减收藏：http://hi.baidu.com/echolovejose/item/2bf4b35af54204cdd2e10c77--MONTHS_BETWEEN(date2,date1)给出date2-date1的月份SQL> select months_between('19-12月-1999','19-3月-1999') mon_between from dual;MON_BETWEEN----------- 9SQL>select months_between(to_date('2000.05.20',&# 阅读全文