what is the difference between trigger and storedprocedures
Answer Posted / nancy
BASIC DIFFERENCE IS trigger is automatically executed without an action required by a user where as stored procedure needs to be explicitly invoked...
a database TRIGGER ia a STORED PROCEDURE that is fired when an insert,update or deletestatements is issued against the associate table.a trigger is fired whwn database related event occurs....
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What problem one might face while writing log information to a data-base table in pl/sql?
What is rename in sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Can you have more than one trigger on a table?
Is it possible to read/write files to-and-from PL/SQL?
What is the command used to fetch the first 5 characters of a string?
What are all the different normalizations?
What are the types pl/sql code blocks?
What are dml commands?
What is sql profiling in oracle?
What is the difference between having and a where in sql?
What is data type in database?
What is a sql driver?
What is a scalar value in sql?
what is a cursor? : Sql dba