Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 25586 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / sohail
1.Procedure is a subrotine which completly utilises the
concept of stack.
2.Procedure can be called any time when required where as
trigger once created we cannot stop the trigger to fire
when not required.
3.triggers are fired implicitly where as procedure are
called explicitly by procedure name when required.
4.the p_code of procedure is stored in oracle SGA and can
be global to others.
| Is This Answer Correct ? | 14 Yes | 11 No |
Post New Answer View All Answers
What will you get by the cursor attribute sql%notfound?
How do we use distinct statement? What is its use?
what is the difference between group by and order by in sql? : Sql dba
Why stored procedure is better than query?
Explain isolation levels. : Transact sql
What is package in pl sql?
what is bcp? When does it used? : Sql dba
How do I order by ascending in sql?
What is the execution plan in sql?
How to use sql*plus built-in timers?
Is full outer join same as cross join?
What is the use of prepared statement?
What is database migration?
explain the delete statements in sql
How do I install microsoft sql?
