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 process query result in pl/sql?
Mention what is the use of function "module procedure" in pl/sql?
What are the most important ddl statements in sql?
which operator is used in query for pattern matching? : Sql dba
How do I delete a trigger?
Is delete faster than truncate?
What are sql triggers used for?
what is “go” in t-sql? : Transact sql
Define SQL and state the differences between SQL and other conventional programming Languages?
Does sql support programming?
What is mutating sql table?
What is rename in sql?
how many ways to get the current time? : Sql dba
What is a subquery in sql?
Explain commit, rollback and savepoint.