1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the types of triggers ?

Question Posted / nitin

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

What is before trigger?

558

What are aggregate and scalar functions?

527

How do I save a sql query?

546

How do I order columns in sql?

532

What is an oracle stored procedure?

592




Explain constraints in sql?

575

What is difference between rank () row_number () and dense_rank () in sql?

581

What is cross join example?

556

I need a function for a train ticket reservation please answer it thanks in advance

565

how to create a new table by selecting rows from another table in mysql? : Sql dba

563

What is data profiling in sql?

519

What is numeric function sql?

544

Define join and name different types of joins?

520

Can you have a foreign key without a primary key?

510

What are the qualities of 2nf?

546