What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 23729 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 is sql procedures and functions?
Can we use two order by clause in query?
Is a view faster than a stored procedure?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What are properties of the transaction?
Are subqueries faster than joins?
what is collation? : Sql dba
what is row? : Sql dba
Is primary key an index?
what are the features and advantages of object-oriented programming? : Sql dba
Can function return multiple values in sql?
What is the execution plan in sql?
What is data manipulation language?
Explain the difference between sql and mysql.
Which language is used in sql?
