what is the difference between trigger and storedprocedures
Answer Posted / srikanth
Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.
triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to run sql*plus commands in sql developer?
Which are sql * plus commands?
What are character functions in sql?
what is rdbms? : Sql dba
What is forward declaration in pl sql?
What is relationship? How many types of relationship are there?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is cold data?
When is the update_statistics command used?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is t-sql? : Transact sql
What is sap sql anywhere?
Which sorts rows in sql?
How many developers work on postgresql?
What is pivot table in sql?