what is the difference between trigger and storedprocedures
- 16 Answers
- 29462 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / nandkumar
There are bascis 3 difference between them
1> trigger invokes implicitly while we need to invoke
procedure explicitly.
2> We cant pass values from user to trigger but we can pass
values into procedure.
3> Trigger cant return value procedure can return value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a database and a relational database?
How to Execute a Package in PL/SQL.?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is view explain with example?
What is the most common sql injection tool?
What is exit statement?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is a sql*loader control file?
What does select * from mean in sql?
Can a trigger call a stored procedure?
What is the difference between view and stored procedure?
Can we update views in sql?
how many tables will create when we create table, what are they? : Sql dba
What is an index in sql with example?
What are the dml statements?
