~SingleForum~无废话记录~ Topic: 触发器的设置 http://www.ll19.com/bb/ ~19~记录点有用的好吗？少说废话少装b~ en Tue, 07 Feb 2012 08:49:21 +0000 admin on "触发器的设置" http://www.ll19.com/bb/topic/39#post-39 Mon, 16 Mar 2009 08:52:06 +0000 admin 39@http://www.ll19.com/bb/ <p>1.首先在ORACLE服务器的NET中建立一个需要触发数据库的连接 比如叫@LINK_200<br /> 2.打开PLSQL 在DATABASE LINE中右键选择新建 用户名口令是需要触发数据库的用户名和口令 数据库是配置的NET连接最后起的名字 名称随意<br /> 3.写需要触发的语句 例如<br />
PLAIN TEXT
SQL:
  1. &#60;br /&#62;
  2. CREATE OR REPLACE TRIGGER TRI_GROUP_PROP&#60;br /&#62;
  3. AFTER INSERT OR UPDATE OR DELETE ON EISS_TAB_GROUP_PROP&#60;br /&#62;
  4. REFERENCING NEW AS NEW OLD AS OLD&#60;br /&#62;
  5. FOR EACH ROW&#60;br /&#62;
  6. BEGIN&#60;br /&#62;
  7.   IF INSERTING THEN&#60;br /&#62;
  8.     INSERT INTO &#60;a href=&#34;mailto:EISS_TAB_GROUP_PROP@LINK_200&#34;&#62;EISS_TAB_GROUP_PROP@LINK_200&#60;/a&#62;&#60;br /&#62;
  9.       (U_GROUPID,&#60;br /&#62;
  10.        PROPID,&#60;br /&#62;
  11.        PROPVALUE)&#60;br /&#62;
  12.     VALUES&#60;br /&#62;
  13.       (:NEW.U_GROUPID,&#60;br /&#62;
  14.        :NEW.PROPID,&#60;br /&#62;
  15.        :NEW.PROPVALUE);&#60;br /&#62;
  16.   ELSIF UPDATING THEN&#60;br /&#62;
  17.     UPDATE &#60;a href=&#34;mailto:EISS_TAB_GROUP_PROP@LINK_200&#34;&#62;EISS_TAB_GROUP_PROP@LINK_200&#60;/a&#62;&#60;br /&#62;
  18.        SET PROPID    = :NEW.PROPID,&#60;br /&#62;
  19.            PROPVALUE = :NEW.PROPVALUE&#60;br /&#62;
  20.      WHERE U_GROUPID = :OLD.U_GROUPID;&#60;br /&#62;
  21.   ELSIF DELETING THEN&#60;br /&#62;
  22.     DELETE FROM &#60;a href=&#34;mailto:EISS_TAB_GROUP_PROP@LINK_200&#34;&#62;EISS_TAB_GROUP_PROP@LINK_200&#60;/a&#62; WHERE U_GROUPID = :OLD.U_GROUPID;&#60;br /&#62;
  23.   END IF;&#60;br /&#62;
  24. END;&#60;br /&#62;

</p> <p>则 打开PLSQL 在TRIGGERS中就会有TRI_GROUP_PROP的触发器</p> <p>SQL中@LINK_200指的是触发@LINK_200这个数据库</p> <p>
PLAIN TEXT
SQL:
  1. &#60;br /&#62;
  2. AFTER INSERT OR UPDATE OR DELETE ON EISS_TAB_GROUP_PROP&#60;br /&#62;

</p> <p>指的是在执行INSERT OR UPDATE OR DELETE ON EISS_TAB_GROUP_PROP后执行相应的语句 </p>