define different types of trigger. : Sql dba

Answer Posted / kiran r

Triggers are classified as follows
1. Based on Trigger level
Row level Trigger and Statement level trigger
2. Based on time
Before, after, Instead
3. Based on Event
DDL, DML,Database Trigger

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 create an update query?

702


Why do we use partitions in sql?

719


How do I make my sql query run faster?

662


What is record in pl sql?

768


How do you go back in sql?

698






Are views faster than queries?

725


what is try_catch block in procedure

1392


What are the main features of cursor?

824


How to return multiple rows from the stored procedure?

714


what is rdbms? : Sql dba

758


What is a pdo connection?

684


Are pl sql variables case sensitive?

769


Is microsoft sql free?

778


What is delimiter in pl sql?

739


what is an alias command? : Sql dba

727