建立函数 create or replace function test(table_name varchar2) return number is r_count number; your_sql varchar2(100); begin your_sql := 'select count(*) from '||rtrim(ltrim(table_name)); execute immediate your_sql into r_count; return r_count; end; /测试函数 select test('你的表名') from dual;
把表明当字符串传进去,使用动态sql,得到其记录数
create or replace function test(table_name varchar2)
return number is
r_count number;
your_sql varchar2(100);
begin
your_sql := 'select count(*) from '||rtrim(ltrim(table_name));
execute immediate your_sql into r_count;
return r_count;
end;
/测试函数
select test('你的表名') from dual;