我要在后台ORACLE数据库中写Triger啊, 我怎么运行这句sql:=' ... from '||t_b_product 请教!!!!!!
try: create or replace procedure insertSQL( t_b_product in varchar2) as v_insertSQL varchar2(1000); begin v_insertSQL:='insert '||t_b_product||' (department) values(''值'')'; execute immediate v_insertSQL; end; /
更正: create or replace procedure insertSQL( t_b_product in varchar2) as v_insertSQL varchar2(1000); begin v_insertSQL:='insert into '||t_b_product||' (department) values(''值'')'; execute immediate v_insertSQL; end; /
...
sql:=' ... from '||t_b_product;
我怎么运行这句sql:=' ... from '||t_b_product
请教!!!!!!
create or replace procedure insertSQL(
t_b_product in varchar2) as
v_insertSQL varchar2(1000);
begin
v_insertSQL:='insert '||t_b_product||' (department) values(''值'')';
execute immediate v_insertSQL;
end;
/
create or replace procedure insertSQL(
t_b_product in varchar2) as
v_insertSQL varchar2(1000);
begin
v_insertSQL:='insert into '||t_b_product||' (department) values(''值'')';
execute immediate v_insertSQL;
end;
/