what is the difference between trigger and storedprocedures
Answer Posted / nandkumar
There are bascis 3 difference between them
1> trigger invokes implicitly while we need to invoke
procedure explicitly.
2> We cant pass values from user to trigger but we can pass
values into procedure.
3> Trigger cant return value procedure can return value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between rename and alias?
how many triggers are allowed in mysql table? : Sql dba
What are the various levels of constraints?
What is crud stand for?
what is a trigger in mysql? : Sql dba
What is sql key?
What is procedure function?
What is java sql package?
What is dml statement?
what is isam? : Sql dba
What is set serveroutput on in pl sql?
What are different types of keys?
how do you tune the slow running queries in oracle db , explain the methodology
What is pl sql code?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba