摘要: http://blog.csdn.net/alex197963/article/details/2036500【转】PRAGMA AUTONOMOUS_TRANSACTION oracle 自治事务 阅读全文
posted @ 2012-07-31 17:43 王道健 阅读(232) 评论(0) 推荐(0) 编辑
摘要: http://blog.csdn.net/justdo2008/article/details/4137779http://xiaoxinshome.iteye.com/blog/139609SQL> CREATE TABLE T(ID NUMBER(18),MC VARCHAR2(20),DT DATE);表已创建。SQL> CREATE OR REPLACE TRIGGER TR_T2AFTER DELETE ON T3FOR EACH ROW4DECLARE V_COUNT NUMBER;5--PRAGMA AUTONOMOUS_TRANSACTION;6BEGIN7 INS 阅读全文
posted @ 2012-07-31 12:31 王道健 阅读(9623) 评论(0) 推荐(0) 编辑