Oracle Forms 3.0 - What are the types of TRIGGERS ?

GeekInterview.com > Interview Questions > Oracle > Oracle Forms 3.0

Go To First | Previous Question | Next Question

Oracle Forms 3.0 | Question 9 of 66

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

mukts

RE: What are the types of TRIGGERS ?

Block Processing

Interface

Is this answer useful? Yes | No

December 06, 2006 09:28:33

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

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

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

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

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

User Name		Remember Me?
Password

Question Bank