可以直接写啊,如下: create or replace procedure your_pro_name() as internal_par_1 char(10); internal_par_2 int; begin ... end
trigger: create or replace trigger trig_name after update on tabelname for each row declare v_name varchar2(100); <---变量 begin .... end ;procedure: create or replace procedure proc_name(..参数) as v_name varchar2(100); <---变量 begin .... end ;
create or replace procedure your_pro_name() as
internal_par_1 char(10);
internal_par_2 int;
begin
...
end
create or replace trigger trig_name
after update on tabelname
for each row
declare
v_name varchar2(100); <---变量
begin
....
end ;procedure:
create or replace procedure proc_name(..参数) as
v_name varchar2(100); <---变量
begin
....
end ;
谢谢回答.