What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 23763 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
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What are local and global variables and their differences?
What is the difference between functions, procedures, and packages in pl/sql?
Why we use sql profiler?
Explain the rollback statement?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
what is the difference between primary key and unique key? : Sql dba
Is sql a dbms?
What are the advantages of sql? Explain
discuss about myisam index statistics collection. : Sql dba
Which tcp/ip port does sql server run?
How do you remove duplicate records from a table?
What are the different operators available in sql?
Why is a trigger used?
what is the syntax used for partition in tsql? : Transact sql
