Trigger Execution Sequence Of Oracle Forms

san.hang

于 2016-12-25 19:11:00 发布

阅读量107

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/quanweiru/p/6220228.html

本文详细介绍了数据库中触发器的不同类型及其执行顺序，包括提交时触发的序列、表单打开关闭时触发的序列以及从一项导航到另一项时触发的序列。这些信息对于理解数据库触发器的工作原理至关重要。

Sequence of triggers fires on Commit.

1. KEY Commit
2. Pre Commit
3. Pre/On/Post Delete
4. Pre/On/Post Update
5. Pre/On/Post Insert
6. On commit
7. Post Database Commit

Sequence of triggers fires when Form is opened and closed.

On Open
1. Pre-Logon
2. On-Logon
3. Post-Logon
4. Pre-Form
5. When-Create-Record
6. Pre-Block
7. Pre-Record
8. Pre-Text-Item
9. When-New-Form-Instance
10. When-New-Block-Instance
11. When-New-Record-Instance
12. When-New-Item-Instance
On Close
1. Post-Text-Item
2. Post-Record
3. Post-Block
4. Post-Form
5. On-Rollback
6. Pre-Logout
7. On-Logout
8. Post-Logout

Sequence of triggers fires when Navigating from one item to another.

1. Key-next
2. Post Change
3. When validate
4. Post text
5. Pre text
6. When new item instance

转载于:https://www.cnblogs.com/quanweiru/p/6220228.html