摘要：
create or replace function getlastdate(tablename in varchar2,sumtype in varchar2) return varchar2 is2v_lastdate varchar2(8);3v_sql varchar2(200);4begin5v_sql := 'select to_char(max(C_ENDDATE),''yyyymmdd'') from '|| tablename ||' where C_SUMTYPE = '''||sumtype 阅读全文
posted @ 2013-05-27 17:44 潘小博1992 阅读(279) 评论(0) 推荐(0) 编辑