 |
| 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
0 Comments