Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32905 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 use of pl/sql table?
What are sql ddl commands?
What is a primary key example?
What is a left inner join?
Why do we use partitions in sql?
How do I start sql from command line?
What is triggering circuit?
What is identity column in sql server?
What is pl sql collection?
How do you modify a table in sql?
How you improve the performance of sql*loader? : aql loader
What are tables and fields in the database?
What is varchar example?
Does oracle roll back the transaction on an error?
Is sql difficult?
