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
- 25213 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 dml with example?
What is the cause of mutating table error and how can we solve it?
what is collation? : Sql dba
What is the use of procedures?
Why do we use joins?
what is column? : Sql dba
What are sql queries used for?
What is database sql?
Can we use update in sql function?
Can we insert data into view?
How many types of functions are there in sql?
How to get unique records from a table?
Why is nosql good?
Explain the select statement in sql?
What is sharding in sql?
