Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are different type of triggers?

April 26, 2017different triggers type

0

Posted

What are different type of triggers?

1 Answer

0

Posted

The following are the different type of triggers they are\ 1. Key-triggers 2. Navigational Triggers. 3. Transactional Triggers. 4. Query-based Triggers 5. Validation Triggers 6. Message – Error handling Triggers. 104. What is the difference between the Restricted and Un-Restricted Packaged Procedure? Any packaged procedure that does not interfere with the basic function of SQL*Forms is an unrestricted packaged procedure. The un-restricted packaged procedure can be used in all types of triggers. Any packaged procedure that affects basic SQL*FORMS fucntion is a restricted packaged procedure. Restricted packaged procedure can be used only in key-triggers and user-named triggers. 105. What is a system variables. A System variable is a SQL*Forms variable that keeps track of some internal process of SQL*Forms in state. The system variable helps us to control the way an application behaves. SQL*Forms maintains the value of a system on a performance basis. That is the values of all the system