Sign Up Login


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

which will default fire first 
statement level trigger or row level trigger

Question Posted / nishi

Answers were Sorted based on User's Feedback



which will default fire first  statement level trigger or row level trigger..

Answer / vijay

Statement level trigger is default trigger

Is This Answer Correct ?    15 Yes 0 No

which will default fire first  statement level trigger or row level trigger..

Answer / ram

Before Insert/update/delete triggers executes first..
In this statement level triggers execute first..the order flows as below
Statement level -- before trigger
row level -- before trigger
row level -- after Insert/update/delete triggers
statement level -- after Insert/update/delete triggers

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is loop in pl sql?

0 Answers  

What is sqlcommand?

0 Answers  

How do u count no of rows in a table?

8 Answers   CTS,

What is nested table in pl sql?

0 Answers  

What is a pl/sql block?

0 Answers  




How many types of primary keys are there?

0 Answers  

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

What is the difference between database trigger and stored procedure?

0 Answers  

Do view contain data?

6 Answers   Ramco,

What are the different dcl commands in sql?

0 Answers  

Which is faster view or stored procedure?

0 Answers  

how to do backup entire database? : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories