oracle视图创建 存储过程创建 触发器创建

create or replace force view("xx")
select 'a' as xx from dual

set difine off;
 create or replace procedure  zzz(pin in int )
as 

c int;
begin

end

set defin off;
create or replace procedure xxx(a in int,b in number)
as
aa int;
aam number;
ccc varchar(50);
begin

end

end xxx;
commit;

create or repalce procedure xxx(pin in int) as
a int;
begin

end
end xxx;
commit;

create or   replace  trigger xxx 
before insert or update or delete on  xxtable  
for each row

declare ss int;
aa int;
begin

select  :new.id into aa from xxtable;
insert into xtable(bb) value(aa);
ommit;

end;

creacte or replace trigger xx
before insert or update on xxtable 
for each row
declare x int;
begin

create or replace trigger zzaa
cefore insert or update on vvtable
for each row
declare aa int;
begin

select :new.id into aa from dual; 
end;
commit;