写了一个函数 create or replace function test(tablename in varchar2,fieldname in varchar2,fieldvalue in varchar2) return number is sqlstr varchar2(1000); records number(10); begin sqlstr := 'select count(rowid) from '||tablename||' where '||fieldname||'='''||fieldvalue||''''; execute immediate sqlstr into records; return records; end;
create or replace function test(tablename in varchar2,fieldname in varchar2,fieldvalue in varchar2)
return number
is
sqlstr varchar2(1000);
records number(10);
begin
sqlstr := 'select count(rowid) from '||tablename||' where '||fieldname||'='''||fieldvalue||'''';
execute immediate sqlstr into records;
return records;
end;