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

Can we call stored procedure in function?

628


How to get help at the sql prompt?

739


Explain the commit statement.

688


What is the difference between delete and truncate statement in sql?

585


What is your daily office routine?

1895






What is partition in sql query?

608


How to write html code in pl sql?

687


How many types of cursors supported in pl/sql?

696


What is an intersect?

745


What is sql resultset?

633


What is forward declaration in pl sql?

664


Is sql developer case sensitive?

635


Explain scalar functions in sql?

676


How do I enable sql encryption?

616


how to drop an existing view in mysql? : Sql dba

693