MS SQLSERVER的帮助里面说得非常详细 如果你不知道怎么用,就打开查询分析器: 输入 Create trigger 然后全选,按 shift + F1 同理 create proc create view
//(存储过程) create or replace procedure user_initialize as begin delete from bua_organization; insert into bua_organization values(1, 'name', 'code', 0); commit; exception when others then rollback; raise; end;//视图 create or replace view 视图名 as select 查询的字段 from 查询的表名 where 查询条件;//触发器 CREATE OR REPLACE TRIGGER "SZJC06".item_del before delete on item for each rowdeclare iCount number(6); begin delete checkitems where checktype='iid' and year=:old.year and setid=:old.setid and instr(checkitem,:old.iid)=1; end item_del;
如果你不知道怎么用,就打开查询分析器:
输入 Create trigger 然后全选,按 shift + F1
同理 create proc
create view
create or replace procedure user_initialize as
begin
delete from bua_organization;
insert into bua_organization values(1, 'name', 'code', 0);
commit;
exception
when others then
rollback;
raise;
end;//视图
create or replace view 视图名 as
select 查询的字段 from 查询的表名 where 查询条件;//触发器
CREATE OR REPLACE TRIGGER "SZJC06".item_del
before delete on item
for each rowdeclare
iCount number(6);
begin
delete checkitems where checktype='iid' and year=:old.year
and setid=:old.setid and instr(checkitem,:old.iid)=1;
end item_del;