ITPub博客

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

[转]Trigger Toutorial

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

Trigger Toutorial

 Triggers

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: http://blog.csdn.net/pan_tian/article/details/7444915

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26687597/viewspace-721782/,如需转载,请注明出处,否则将追究法律责任。

下一篇: [原]EBS File Types
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

  • 博文量
    718
  • 访问量
    2260738