给个参考:
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;
来不及写,引用其它兄弟的。
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;
来不及写,引用其它兄弟的。
然后:
select ... from '|v_tableName||;
create or replace function insert_test(p_table_name varchar2,
p_view_name varchar2,
n munber
)
return number
is
sql_string varchar2(500);
sql_string1 varchar2(500);
begin
sql_string := 'insert into '||p_table_name||' values((:1) ';
execute immediate sql_string using n;
sql_string1 := 'insert into '||p_view_name||' values((:1) ';
execute immediate sql_string1 using n;
return 0;
end insert_test;
sql_string := 'insert into '||p_table_name||' values((:1) ';
sql_string1 := 'insert into '||p_view_name||' values((:1) ';
改为
sql_string := 'insert into '||p_table_name||' values(:1) ';
sql_string1 := 'insert into '||p_view_name||' values(:1) ';