what is the difference between trigger and storedprocedures

Answer Posted / bhanu verma

Actually triger in action which is performed automatically
before or after a event occur and stored procedure is a
procedure which is executed when the it is called.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is file based approach?

495


Does google use sql?

518


How to look at the current sql*plus system settings?

608


Which is better join or subquery?

610


What are two statement types in sql?

540






What is data types in sql?

539


What are the different types of a subquery?

525


What is the difference between count 1 and count (*) in a sql query?

506


Explain the significance of the & and && operators in pl sql.

575


How to write pl sql program in mysql command prompt?

521


How do I view a procedure in sql?

553


Can procedure in package be overloaded?

614


What is the difference between cross join and natural join?

570


What is difference between hql and sql?

514


What is the difference between the sql*loader and import utilities? : aql loader

604