Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 31895 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
How do I pipe the output of one isql to another?
What are the set operators in sql?
How do I truncate a sql log file?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is parallel hint?
How many types of indexes are there in sql?
Can variables be used in sql statements?
explain access control lists. : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
What are the string functions in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
Is primary key always clustered index?
tell me about various levels of constraint. : Sql dba
Can we commit in trigger?
What is data profiling in sql?
