what is the difference between trigger and storedprocedures
- 16 Answers
- 29430 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 is the location of pre_defined_functions.
How do you get column names only for a table (sql server)?
What is procedure in pl sql?
How do I find sql profiler?
What are the basic techniques of indexing?
What is dba in sql? : SQL DBA
What is difference between hql and native sql?
What is not in sql?
What is varray in pl sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Show code of a cursor for loop.
what is a database? : Sql dba
What is composite primary key in sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is sql basics?
