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
- 25408 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 are the different types of triggers?
What is partition by in sql?
What are the 3 modes of parameter?
Define tables and fields in a database
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is pl/sql table? Why is it used?
What is the difference between inner join and outer join?
Why do we need sharding?
How can you select unique records from a table?
How do I view tables in sql developer?
How do I audit the sql sent to the server?
What is cost in sql execution plan?
Can we insert in view in sql?
State few characteristics of pl/sql?
How delete all data from table in sql?
