What are the types of triggers ?

Answer Posted / kumar sudeep

1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

All the above with differences in areas of implementaion
difference as below:
1. Database.
2. Application.

And with ways of implementation differences as below:
1. BEFORE/AFTER.
2. Insert/Update/delete.
3. Statement level/Row level.

Is This Answer Correct ?    12 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a record in a database?

559


how to fetch alternate records from a table? : Sql dba

590


Does group by remove duplicates?

545


Write a sql query to convert all character to uppercase after hypen.

957


what is the difference between blob and text? : Sql dba

523






What is a rank in sql?

534


Is sql considered coding?

567


What is a primary key sql?

559


How do you declare a variable in pl sql?

529


how many sql ddl commands are supported by 'mysql'? : Sql dba

519


What are packages in pl sql and also explain its advantages?

530


Show the cursor attributes of pl/sql.

607


what is unique key constraint? : Sql dba

562


How many types of triggers exist in pl/sql?

561


What is compute?

555