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 / sohail

Trigger and procedures are same but the substantial
difference is when they run.procedure is invoked explicitly
by the user and trigger is executed implicitly. another
diffrence is procedure cannot have the same name as table
name,funtion name or package name but trigger can have same
name as table name or procedure name.

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does varchar include?

994


Why we use cross join?

1000


What does the sign mean in sql?

1049


What is implicit cursor in pl sql?

1148


What is the importance of sqlcode and sqlerrm?

1394


What is linq to sql?

1179


What are the types of operators available in sql?

1127


Mention what does plv msg allows you to do?

1164


What is record variable?

1042


Does sap use sql?

1041


Is merge a dml statement?

1030


What are the methods of filing?

992


What is column?

1033


Why is pl sql needed?

1004


Where the sql database files are stored?

1078