oracle 觸發器 client 事件
轉自:http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg14evt.htm#1000872
Client Events
Client events are the events related to user logon/logoff, DML, and DDL operations. For example:
CREATE OR REPLACE TRIGGER On_Logon
AFTER LOGON
ON The_user.Schema
BEGIN
Do_Something;
END;
The LOGON and LOGOFF events allow simple conditions on UID( ) and USER( ). All other events allow simple conditions on the type and name of the object, as well as functions like UID( ) and USER( ).
The LOGON event starts a separate transaction and commits it after firing the triggers. All other events fire the triggers in the existing user transaction.
The LOGON and LOGOFF events can operate on any objects. For all other events, the corresponding trigger cannot perform. any DDL operations, such as DROP and ALTER, on the object that caused the event to be generated.
The DDL allowed inside these triggers is altering, creating, or dropping a table, creating a trigger, and compile operations.
If an event trigger becomes the target of a DDL operation (such as CREATE TRIGGER), it cannot be fired later during the same transaction
Table 16-3 contains a list of client events.
Table 16-3 Client EventsEvent | When Fired? | Attribute Functions |
---|---|---|
BEFORE ALTER |
When a catalog object is altered. |
ora_sysevent |
BEFORE DROP |
When a catalog object is dropped. |
ora_sysevent |
BEFORE ANALYZE |
When an analyze statement is issued |
ora_sysevent |
BEFORE ASSOCIATE STATISTICS |
When an associate statistics statement is issued |
ora_sysevent |
BEFORE AUDIT |
When an audit or noaudit statement is issued |
ora_sysevent |
BEFORE COMMENT |
When an object is commented |
ora_sysevent |
BEFORE CREATE |
When a catalog object is created. |
ora_sysevent |
BEFORE DDL |
When most SQL DDL statements are issued. Not fired for ALTER DATABASE, CREATE CONTROLFILE, CREATE DATABASE, and DDL issued through the PL/SQL procedure interface, such as creating an advanced queue. |
ora_sysevent |
BEFORE DISASSOCIATE |
When a disassociate statistics statement is issued |
ora_sysevent |
BEFORE GRANT |
When a grant statement is issued |
ora_sysevent |
BEFORE LOGOFF |
At the start of a user logoff |
ora_sysevent |
AFTER LOGON |
After a successful logon of a user. |
ora_sysevent |
BEFORE RENAME |
When a rename statement is issued. |
ora_sysevent |
BEFORE REVOKE |
When a revoke statement is issued |
ora_sysevent |
AFTER SUSPEND |
After a SQL statement is suspended because of an out-of-space condition. The trigger should correct the condition so the statement can be resumed. |
ora_sysevent |
BEFORE TRUNCATE |
When an object is truncated |
ora_sysevent |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-620846/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle觸發器6(建立系統事件觸發器)Oracle觸發器事件
- 有趣的觸發器事件觸發器事件
- Oracle觸發器Oracle觸發器
- Oracle觸發器觸發級別Oracle觸發器
- mvvm模式 事件觸發器[wpf]MVVM模式事件觸發器
- ORACLE DDL觸發器Oracle觸發器
- Oracle之觸發器Oracle觸發器
- oracle ddl 觸發器Oracle觸發器
- 根據業務寫觸發器(oracle觸發器片)觸發器Oracle
- ORACLE觸發器詳解Oracle觸發器
- Oracle登陸觸發器Oracle觸發器
- oracle 觸發器-表同步Oracle觸發器
- Oracle 登入觸發器Oracle觸發器
- 取消事件觸發事件
- Oracle開發基礎-觸發器Oracle觸發器
- oracle 批量刪除觸發器Oracle觸發器
- oracle 觸發器的例項Oracle觸發器
- Oracle 觸發器 限制DDL操作Oracle觸發器
- Oracle 觸發器中使用遊標Oracle觸發器
- Oracle觸發器詳細介紹Oracle觸發器
- 使用 jQuery 觸發 Vue 事件jQueryVue事件
- 取消事件觸發(妙啊)事件
- jQuery select 觸發事件jQuery事件
- JavaScript 模擬事件觸發JavaScript事件
- oracle儲存過程和觸發器Oracle儲存過程觸發器
- Oracle中觸發器的應用 (zt)Oracle觸發器
- oracle觸發器~ 更新多表的問題Oracle觸發器
- oracle trigger觸發器這servererrorOracle觸發器ServerError
- Oracle Instead of 觸發器的使用Oracle觸發器
- Oracle資料庫DDL審計觸發器觸發的bug問題Oracle資料庫觸發器
- Android觸控事件(下)——事件的分發Android事件
- 如何觸發react input change事件React事件
- WebSocket的事件觸發機制Web事件
- Yii中事件觸發機制事件
- 禁止oracle表的觸發器triggerOracle觸發器
- ORACLE 觸發器語法及例項 一Oracle觸發器
- ORACLE 觸發器語法及例項 二Oracle觸發器
- ORACLE 觸發器語法及例項 三Oracle觸發器