几个ORACLE个触发器!

关注

原创最新推荐文章于 2026-04-24 09:32:00 发布 816 阅读 AI 写同款· GEO 优化 ›

代谢组数据分析（十五）：基于python语言构建PLS-DA分类预测模型本教程阐述典型代谢组学数据分析工作流程，用于二元分类结果的研究。流程主要步骤如下：首先从 Excel 表格导入代谢物与实验数据，接着基于汇总 QC 进行数据清洗。随后借助主成分分析可视化检查数据质量，再开展两类单变量统计。之后运用偏最小二乘判别分析（PLS - DA）实施多变量分析，此过程涵盖模型优化（对比 R2 与 Q2）、置换测试及明确模型预测指标、确定特征重要性、对模型预测数据进行可视化。最终将统计表格导出至 Excel 表格，完整呈现从数据导入到分析结果输出的全过程。阅读详情

create or replace trigger tri_SERVICE_TYPE
before Delete on SMS_SERVICE_TYPE
for each row
Declare

   Cant_Delete Exception;
Begin
   If Deleting Then
      --不允许删除
      Raise Cant_Delete;
   End If;
   Exception
   When Cant_Delete Then
      Raise_Application_Error(-20007, '不允许删除操作'); --Raise_Application_Error的用法在07-11-29日志中有介绍。
End;

create or replace trigger tri_message302
before Insert on sms_message302
for each row
Declare
v_num1 number(10);
v_num2 number(10);
Begin
If Inserting Then
   v_num1 :=instr(:New.Content,':',1,1);
   v_num2 :=instr(:New.Content,'：',1,1);
   If v_num1 > 0 Then

    :New.Content := replace(:New.Content,substr(:New.Content,1,v_num1-1),'影视报道');
   Elsif v_num1 = 0 And v_num2 > 0 Then
    :New.Content := replace(:New.Content,substr(:New.Content,1,v_num2-1),'影视报道');
   End If;

End If;

Exception
When Others Then
Null;
End tri_message302;
/

create or replace trigger TRI_MISCRULE12
before insert or update on SMS_MISC_RULE_1_2
for each row
declare
SEQNO NUMBER(6);
begin

IF Upper(:new.MISCORDER) IN ('OTHERS','NULL') then
    :new.MISCORDER:=Upper(:new.MISCORDER);
    :new.ORDERlen:=0;
ELSE
    :new.MISCORDER:=Upper(:new.MISCORDER);
    :new.ORDERlen:=length(:new.MISCORDER);
END IF;
IF upper(:new.SMSCODE)='NORMAL' then
    :new.SMSCODE:='NORMAL';
:new.SMSMODE:=0;
:new.SMSLEN:=0;
ELSE
   :new.SMSLEN:=Length(:new.SMSCODE);
END IF;
   If Nvl(To_Char(:New.Ruleid), 'NULL') = 'NULL' Then
       SELECT SMS_MISC_RULESEQ.NEXTVAL INTO SEQNO FROM DUAL;
       :new.RULEID:=SEQNO;
   End If;