Header Ads Widget

Responsive Advertisement

Module 14: Producing Triggers

Producing Triggers

01. Write the steps for creating trigger?

Steps for creating a trigger:

Step One: Select Trigger Scope

Step Two: Invoke the Trigger LOV

Step Three: Use the PL/SQL Editor to define the trigger Code

Step Four:  Compile 

02. Write the feathers of PL/SQL?

•  Automatic formatting and coloring PL/SQL code.

•  Automatic indenting and color syntax highlighting.

•  Drag and drop text manipulation.

•  Unlimited undo/redo.

•  Multiple spilt views.

03. Write the trigger component of the PL/SQL Editor

Trigger components of the PL/SQL Editor.

•  Type

•  Object

•  Item

•  Name 

•  Source Pane

•  Toolbar

04. What are the things to remember about the PL/SQL Editor? 

•  New and changed text in the triggers remains compiled until we click compile.

•  Compiling trigger that contain SQL require connection to the database.

•  All uncompiled triggers are compiled when the form module is compiled. 

•  The Block and Item pop-up list do not change the current trigger scope. They enable you to switch to another trigger. 

05. What are the things to remember about the PL/SQL Editor? 

•  PL/SQL variables must be declared in trigger or defined in a package.

•  Forms Builder variables:

# Are not formally declared in PL/SQL.

# Need a colon (:) prefix in reference.

06. Write about the PL/SQL variable?

PL/SQL variable must be declare in a DECLARE section and remain available until the end of the declaring block

07. Write the Forms Builder Variables

Forms Builder Variables are following:

•  Items

•  Global variable 

•  System variables

•  Parameters

08. Write about When-Button-Pressed Trigger

When-Button-Pressed Trigger fires when the user clicks a button. It accepts both restricted and unrestricted built-ins. we can use it to provide the following functions:

•  Navigation

•  Displaying LOVs

•  Invoking calculations and others functions  

Post a Comment