首页 > Linux操作系统 > Linux操作系统 > [转]Trigger Toutorial

[转]Trigger Toutorial

原创 Linux操作系统 作者:pan_tian 时间:2012-04-20 13:07:16 0 删除 编辑

Trigger Toutorial


1.1 About Triggers and Processes

Triggers are blocks of PL/SQL code that you write to perform. specific tasks. There are pre-defined runtime events for which you can create triggers. Trigger names correspond to these events. For ease of description, the terms events and triggers are synonymous in this chapter. In effect, an Oracle Forms trigger is an event-handler written in PL/SQL to augment (or occasionally replace) the default processing behavior.

A process is a series of individual, related events that occurs during a specific Oracle Forms Runform. operation. Oracle Forms includes navigational, validation, and database transaction processes. To see a visual representation of Oracle Forms processes showing where each trigger fires, refer to the flowchart for the process named in the "Fires In" section for each trigger. All the flowcharts are in the Oracle Forms Reference Manual, Vol. 2, Chapter 8, "Processing Flow Charts".

1.2 SQL Statements in Trigger Text

The trigger descriptions in this chapter include a section called "Legal Commands." This section lists the types of statements that are valid in the indicated trigger type, including:

Link URL:

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: [原]EBS File Types
请登录后发表评论 登录


  • 博文量
  • 访问量