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 is sql rowcount?

952


What is rtm in testing?

1040


What steps server process has to take to execute an update statement?

922


what are the features and advantages of object-oriented programming? : Sql dba

955


What do you mean by field in sql?

1037


How much ram can sql express use?

934


how can we submit a form without a submit button? : Sql dba

918


what is index? : Sql dba

946


Is left join faster than inner join?

1065


What is the difference between joins?

977


Explain spool.

1114


How to combine two stored procedures in sql?

1124


What are the different dcl commands in sql?

1069


Which constraints we can use while creating database in sql?

1018


How to run sql statements with oracle sql developer?

1000