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
- 25364 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
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How many sql statements are used? Define them.
how to rename an existing table in mysql? : Sql dba
How do I view stored procedures?
Which is faster subquery or join?
Does view store data in sql?
What is implicit cursor in pl sql?
What is the difference between having and a where in sql?
What is java sql connection?
Which certification is best for sql?
What are hotfixes and patches?
What is cost in sql execution plan?
What are predefined functions in sql?
How exception handling is done in advance pl/sql?
What is the best sql course?
