Question

动态sql和静态sql

create or replace function get_counts(v_name varchar2)
return number
as
v_count number;
begin
execute immediate
'select count(*) from '||v_name
into v_count;
return v_count;
end;
如果不用动态SQL应该怎么写
create or replace function get_counts(v_name varchar2)
return number
as
v_count number;
begin
select count(*) into v_count from v_name;
return v_count;
end;
这样写的话v_name不能作为变量，该怎么写？

Answer 1

这肯定是动态语句啦～～get_counts()是个自定义函数，真要写成静态的就是
select count(*) from table_name