摘要:
create or replace function GET_COUNT_ZS(deptcode in varchar2, tablename in varchar2,bs in varchar2)return varchar2is num varchar2(1000);c number;beginif(bs=0) then num:='select count(*) from '||tablename||' where deptcode like '''||deptcode||'%''';end if;if(bs 阅读全文