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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between trigger and storedprocedures

Question Posted / nancy

Answer Posted / nancy

BASIC DIFFERENCE IS trigger is automatically executed without an action required by a user where as stored procedure needs to be explicitly invoked...

a database TRIGGER ia a STORED PROCEDURE that is fired when an insert,update or deletestatements is issued against the associate table.a trigger is fired whwn database related event occurs....

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain spool.

1113

how to escape special characters in sql statements? : Sql dba

971

what is a constraint? Tell me about its various levels. : Sql dba

932

Can you load data into multiple tables at once? : aql loader

1024

How do you concatenate in sql?

975

Explain sql data types?

1037

What are stored procedures used for?

962

Is sql free?

889

Can you rollback after commit?

935

Is it possible to read/write files to-and-from PL/SQL?

1039

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

2072

What is update query?

922

what is csv? : Sql dba

946

what are all the common sql function? : Sql dba

1013

What is an inner join sql?

956