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
- 25431 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
Can we create a trigger on view?
what is foreign key? : Sql dba
Explain aggregate functions are available there in sql?
how to create a test table in your mysql server? : Sql dba
What is crud stand for?
what is 'mysqldump'? : Sql dba
How to add, remove, modify users using sql?
Explain the purpose of %type and %rowtype data types?
What are the types of operators available in sql?
Which kind of parameters cannot have a default value in pl sql?
How to call a javascript function from pl sql?
How many row comparison operators are used while working with a subquery?
Can a table have no primary key?
What is substitution variable in pl sql?
what is error ora-03113: end-of-file on communication channel?
