create or replace function f1(p_table_name varchar2, p_field_name varchar2 ) return number is acc_bal number; sql_string varchar2(1000); begin sql_string := 'select count('||p_field_name||') from '||p_table_name; execute immediate sql_string into acc_bal; return (acc_bal); end f1;
p_field_name varchar2
)
return number
is
acc_bal number;
sql_string varchar2(1000);
begin
sql_string := 'select count('||p_field_name||') from '||p_table_name;
execute immediate sql_string into acc_bal;
return (acc_bal);
end f1;