mukts

• Mar 31st, 2006

 

Block Processing

Interface

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

 

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

Nitin Gaur

• Jul 2nd, 2007

 

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.

kirangsv

 Profile Answers by kirangsv 

• Jan 8th, 2008

 

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

anilkln

 Profile Answers by anilkln Questions by anilkln

• Feb 21st, 2008

 

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

kishor s pawar

 Profile Answers by kishor s pawar 

• Mar 17th, 2008

 

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

kishor