GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Oracle Forms 3.0
Go To First  |  Previous Question  |  Next Question 
 Oracle Forms 3.0  |  Question 9 of 66    Print  
What are the types of  TRIGGERS ?
 
1. Navigational Triggers.
   2. Transaction Triggers.



  
Total Answers and Comments: 6 Last Update: March 17, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 31, 2006 04:38:33   #1  
mukts        

RE: What are the types of  TRIGGERS ?

Block Processing

Interface


 
Is this answer useful? Yes | No
December 06, 2006 09:28:33   #2  
rampratap409 Member Since: September 2006   Contribution: 111    

RE: What are the types of  TRIGGERS ?

Trigger in Forms are totaly differ from trigger in oracle.

Forms trigger: base on 1. mouse navigation 2. key navigation 3. Transactional 4. others

oracle trigger: database tigger ( 13) and application trigger


 
Is this answer useful? Yes | No
July 02, 2007 07:58:31   #3  
Nitin Gaur        

RE: What are the types of  TRIGGERS ?
There are two types of trigger. First Row Level and Second Statement Level.

Further trigger is divided based on timing as BEFORE and AFTER.

Moreover based on events trigger is divided as INSERT UPDATE and DELETE.

So total number of triggers are:

(3 (INSERT UPDATE DELETE) * 2 (BEFORE AFTER) * 2 (ROW LEVEL STATEMENT LEVEL)) + 1 (INSTEAD OF ) 13

Basically above text are about database transaction trigger.

 
Is this answer useful? Yes | No
January 08, 2008 13:25:38   #4  
kirangsv Member Since: January 2008   Contribution: 10    

RE: What are the types of TRIGGERS ?
If you are talking about the triggers in forms-6i. There are 2 types of triggers namely
FORM LEVEL TRIGGER BLOCK LEVEL TRIGGER
FORM LEVEL TRIGGER fires to that particular form only
BLOCK LEVEL TRIGGER fires to the entire block ie datablock

 
Is this answer useful? Yes | No
February 21, 2008 13:12:10   #5  
anilkln Member Since: April 2007   Contribution: 2    

RE: What are the types of  TRIGGERS ?
actually there r 3 levels of triggers
1)formlevel 2)block level 3) item level

and types of triggers r
1 activex triggers
2 block processing triggers
3 interface event triggers
4 key triggers
5master detail triggers
6 message handling triggers
7 mouse event triggers
8navigation triggers
9 on triggers
post triggers
pre triggers
query time triggers
stored procedure triggers
transactional triggers
validation triggers
when triggers

 
Is this answer useful? Yes | No
March 17, 2008 08:00:18   #6  
kishor s pawar Member Since: March 2008   Contribution: 2    

RE: What are the types of  TRIGGERS ?
pre triggers post triggers when trigger transactional trigger validation triggers key triggers

kishor

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape