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
- 25417 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
How exception is different from error?
How to read/write files from pl/sql?
How do you create a db file?
What is auto increment in sql?
What is the example of procedure?
what are the advantages of using stored procedures? : Sql dba
Why are indexes and views important to an organization?
What is error ora-01000: maximum open cursors exceeded
How do you take the union of two tables in sql?
Why we use stored procedure instead of query?
What are the ddl commands?
Write the alter statement to enable all the triggers on the t.students table.
How do I delete a trigger?
How do I run a sql script?
Explain table and field in sql?
