how many triggers we can create on a table

Answer Posted / karthik

Hi Aurobinda and Karthikeyan,
see all says the same answer which is NOT right.u can hv
many number of triggers ina table but the COMBINATIONS U
CAN MAKE can be 12 only(karthikeyan ur partly rit)
ex: i can hv before insert on each row trigger 5 times ina
table it means this itself its a 5 trigger but the
combination can be 12 only.

Is This Answer Correct ?    57 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to view all columns in an existing table?

540


What is blob datatype?

558


What are the various oracle database objects?

667


What is BBED in Oracle?

675


Explain the dml?

587






How to bring a tablespace offline?

531


How do I spool to a csv formatted file using sqlplus?

536


Will you be able to store pictures in the database?

629


List out the types of joins.

583


what is reindexing?

1161


What are a collation and state the different types of collation sensitivity?

543


What is a proxy class?

548


What is oracle open database communication (odbc)?

546


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

534


In the oracle version 9.3.0.5.0, what does each number shows?

735