How many triggers can be implemented for a table?

Answer Posted / hairreddy

we can create more no of triggers on a single table but we can apply 12 different type of triggers only on a table
before -- for this table level and row level (insert/update/delete)-----total 6
after-- for this table level and row level (insert/update/delete)-----total 6

total 12 different triggers we can write on a table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you modify a column in sql?

531


What are the datatypes available in pl/sql ?

609


How to Execute a Package in PL/SQL.?

580


How do I tune a sql query?

512


What are the uses of sysdate and user keywords?

624






What does count (*) do in sql?

523


What are sql injection vulnerabilities?

497


What is multiple columns?

572


What are three advantages to using sql?

549


What is the difference between nvl function, ifnull function, and isnull function?

587


explain the delete statements in sql

578


Is a table valued function object?

577


what are the 'mysql' command line arguments? : Sql dba

648


What is bind variable in pl sql?

524


Does varchar need length?

516