8.Oracle创建带参数函数

1.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

create or replace  function shang_test2_fuc(tableName varchar2) return number 
as
t_Count number;
query_sql varchar2(100);

begin

query_sql:='select count(1) from '||  tableName;
execute immediate query_sql  into t_Count;                  -------------动态SQL

return  t_Count;   

end shang_test2_fuc;

----------------------------------------------------------------------------------------------------------

-----------------

测试案例：

—————————————————————————————————————————————————————
declare
ret Number;
begin

-------------------
ret:=shang_test2_fuc('dual');
dbms_output.put_line(ret);
-------------------
end;

-----------------------------------------------------1--------------------------------------------------------------------

declare
ret Number;
t_Count number;
query_sql varchar2(100);
tableName varchar2(100) := 'dual';
begin
query_sql:='select count(1) from '||  tableName;
execute immediate query_sql  into t_Count;
dbms_output.put_line(t_Count);
end;