How many types of trigger can be used in a table at a time ?

Answers were Sorted based on User's Feedback



How many types of trigger can be used in a table at a time ?..

Answer / sree

max of 12

Is This Answer Correct ?    19 Yes 2 No

How many types of trigger can be used in a table at a time ?..

Answer / arun raj

u can define a trigger
1. For Each Row
2. For Each Statement

You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE

So it makes a total of 12.

Is This Answer Correct ?    15 Yes 0 No

How many types of trigger can be used in a table at a time ?..

Answer / shweta

max 12

Is This Answer Correct ?    11 Yes 5 No

How many types of trigger can be used in a table at a time ?..

Answer / shanmugavelu

Max 12 types we can use before/after combination

Is This Answer Correct ?    8 Yes 4 No

How many types of trigger can be used in a table at a time ?..

Answer / a.kondala rao.

1 at a time

Is This Answer Correct ?    4 Yes 3 No

How many types of trigger can be used in a table at a time ?..

Answer / a.kondala rao.

one trigger at a time

Is This Answer Correct ?    5 Yes 4 No

How many types of trigger can be used in a table at a time ?..

Answer / jagadesh

12

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Oracle Forms Reports Interview Questions

What is a Navigable item?

1 Answers  


What is the use of image_zoom built-in?

2 Answers  


What is 4-way match?

2 Answers   Zensar,


What are modalless windows?

1 Answers  


Name of the functions used to get/set canvas properties?

1 Answers  


how to create the triggers in the forms?

3 Answers  


What is the order of the triggers fired once the form is opened?

3 Answers  


What are the two types views available in the object navigator?

1 Answers  


.fmb will be in which folder

2 Answers  


What are the triggers associated with a check box?

2 Answers  


What is the use of Validation triggers in Reports?

2 Answers   GE,


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)