Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 31713 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satish kumar
stored procedure are collections of T-sql statements and
they are pre complied staements,it not requiers any
complitation.
trigger are not pre complied statements , and they are
going to activate only when certain action takes place like
insert , update, delete,
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is oltp (online transaction processing)? : Sql dba
Enlist the characteristics of pl/sql?
What is trigger in pl sql?
Define union, minus, union all, intersect ?
What are the subsets of sql?
What is bitemporal narrowing?
Why coalesce is used in sql?
Can we use rowid as primary key?
What is a record in pl/sql?
Is primary key an index?
what are the types of subquery? : Sql dba
Does oracle roll back the transaction on an error?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is the difference between drop and truncate commands?
