Oracle 触发器
时间: 2023-12-04 19:08:06 浏览: 100
Oracle的触发器分为DML触发器、DDL触发器、替代触发器和系统触发器。DML触发器是在对表进行数据操作时触发的,包括INSERT、UPDATE和DELETE操作等。系统触发器是由Oracle数据库系统事件所触发的,例如startup、shutdown、logon、logoff、servererror和db_role_change等事件。触发器实质上是存储过程,当特定事件发生时,Oracle会执行触发器中的代码。触发器由三个部分组成:触发器执行的条件,即触发器被触发的事件;执行触发器的时间,可以是事件发生之前(before)或事件发生之后(after);以及触发器要执行的任务,即触发后要执行的PL/SQL语句块。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [Oracle 触发器详解](https://blog.csdn.net/KevinChen2019/article/details/127504154)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [Oracle触发器](https://blog.csdn.net/u010806950/article/details/105018320)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文