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

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

Explain table and field in sql?

0 Answers  


Write a query to find second highest salary of an employee.

27 Answers  


Write the order of precedence for validation of a column in a table ?

2 Answers  


What are sql injection vulnerabilities?

0 Answers  


How do you change a value in sql?

0 Answers  






What is the use of primary key?

0 Answers  


How can we solve sql error: ora-00904: invalid identifier?

0 Answers  


display null value rows with out using null function?

8 Answers   Infosys,


Why use stored procedures?

0 Answers  


Is there a 64 bit version of ssms?

0 Answers  


How do I save the results of sql query in a file?

0 Answers  


What is package in pl sql?

0 Answers  


Categories