adspace


What are the types of triggers ?

Answer Posted / nitin

There is
1)DML trigger: with before/after,for each row/for statement,and for 3 types of DML operation.
2)Instead of trigger.
3)Database level trigger: Triggers on DDL statement.
4)System level trigger.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If a cursor is open, how can we find in a pl/sql block?

1252


Is primary key clustered index?

1028


What is the current version of postgresql?

1188


Can we use distinct and group by together?

1147


What is the best sql course?

1064


Can we rollback truncate?

1083


What is the current version of sql?

1106


what are all the common sql function? : Sql dba

1141


Is inner join faster than left join?

1287


how many tables will create when we create table, what are they? : Sql dba

1156


How do I remove duplicates in two columns?

1202


what is sql server agent? : Sql dba

1189


how to escape special characters in sql statements? : Sql dba

1124


how to start mysql server? : Sql dba

1279


what are aggregate and scalar functions? : Sql dba

1142