What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 23734 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / anil_abbireddy
1. Triggers are Table dependent,But Procedures are Not
2. We can not pass Parameters through Triggers,But in case
of sp we can pass no.of parameters
3. We can not execute triggers explicitly,but ps we can
4. we can not place transaction processing statments in
triggers(commit,collback,save point), but in ps. we can
5. we cannot overload triggers, but we can overload
functions & procedures using packages.
| Is This Answer Correct ? | 44 Yes | 8 No |
Post New Answer View All Answers
What is trigger explain it?
What is difference between ms sql and mysql?
What is difference between db2 and sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is sqlcontext?
What is a string data type in sql?
What is forward declaration in pl sql?
What is the difference between having and a where in sql?
how to calculate the difference between two dates? : Sql dba
Why do we use subquery?
What is information schema in sql?
Is oracel sql developer written in java?
Explain what is sql*plus?
Why do we use %rowtype & %type in plsql?
what is a foreign key ? : Sql dba
