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

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

what are the advantages of package?

7 Answers   iFlex,

What are the differences between in and exists clause?

0 Answers  

What is the use of index in sql?

0 Answers  

What is dbo in sql?

0 Answers  




Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

What does truncate mean in sql?

0 Answers  

Is sql better than access?

0 Answers  

what is the command for user data type?

2 Answers  

Explain the working of primary key?

0 Answers  

How to read/write files from pl/sql?

0 Answers  

what is oracle database ? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories