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
- 25194 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / jaya
1) Stored procedures can accept parameters and can return values. Triggers can neither accept parameters nor return values.
2) A Trigger is dependent on a table and the application has no control to not fire a trigger when not needed. On the other hand, a stored procedure can be called as needed.
3) Procedure runs only when one call them manually whereas a trigger runs when there is any activity(insert,update,delete) on table on which the trigger is written.
4) Firing of a stored procedure can be controlled whereas on the other hand trigger will get fired whenever any modification takes place on the table.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sql performance tuning?
What jobs use sql?
What is scalar data type in pl sql?
Is sql easier than java?
What is cartesian join in sql?
What are all ddl commands?
Why procedure is used in sql?
How can we solve sql error: ora-00904: invalid identifier?
What are different types of sql commands?
What does closing a cursor do?
what is the difference between $message and $$message? : Sql dba
What is dcl in sql?
Does sap use sql?
Is sql similar to python?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
