oracle触发器trigger

https://blog.csdn.net/m0_37253968/article/details/120326922

select * from ekp_map_BGYPaddORdel_dt1 where （fd_caozuo='add' or fd_caozuo='upd'） and fd_wenDangZhuangTaiMa='30' 
--删除多列
ALTER TABLE ekp_map_BGYPaddORdel_dt1 DROP(FD_3ABECFB9138756_TEXT,FD_WUPINXINXIBIAOSHIFU)
--清空数据表
delete  ekp_map_bgypaddordel_dt1 
--1.新建一个seqence
create sequence fd_wupinbianhao 
minvalue 1 
maxvalue 999999999
start with 1 
increment by 1 
cache 20 
nocycle;

--trigger触发器
create or replace trigger TG_TR__map_bgypaddordel_dt
1
  before insert on ekp_map_bgypaddordel_dt1
  for each row
  --when 触发条件
begin
  --pl/sql语句;
  select fd_wupinbianhao.nextval into :new.fd_wupinbianhao from dual;
end;

--删除触发器
DROP TRIGGER TG_TR__map_bgypaddordel_dt;