Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference between trigger and storedprocedures

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


Please Help Members By Posting Answers For Below Questions

What is the difference between rename and alias?

1390


how many triggers are allowed in mysql table? : Sql dba

1103


What are the various levels of constraints?

1167


What is crud stand for?

1048


what is a trigger in mysql? : Sql dba

1216


What is sql key?

1045


What is procedure function?

1124


What is java sql package?

1145


What is dml statement?

1001


what is isam? : Sql dba

1066


What is set serveroutput on in pl sql?

1359


What are different types of keys?

1174


how do you tune the slow running queries in oracle db , explain the methodology

3229


What is pl sql code?

1106


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1164