GeekInterview.com
Series: Subject: Topic:
Question: 157 of 165

What are the types of  TRIGGERS ?

 1. Navigational Triggers.   2. Transaction Triggers.
Asked by: Interview Candidate | Asked on: Sep 9th, 2004
Showing Answers 1 - 6 of 6 Answers
mukts

Answered On : Mar 31st, 2006

Block Processing

Interface

  
Login to rate this answer.

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

  
Login to rate this answer.
Nitin Gaur

Answered On : Jul 2nd, 2007

There are two types of trigger. First Row Level and Second Statement Level.

Further trigger is divided based on timingas 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
kirangsv

Answered On : Jan 8th, 2008

View all answers by kirangsv

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

  
Login to rate this answer.

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

  
Login to rate this answer.
kishor s pawar

Answered On : Mar 17th, 2008

View all answers by kishor s pawar

pre triggers,post triggers,when trigger,transactional trigger,validation triggers,key triggers

kishor

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.