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 are the types of triggers ?

Answer Posted / robert son das

There are total four(4) types of triggers..

they are:
before insert----row level
before delete--row level
before update--row level

before insert----statement level
before delete--statement level
before update--statement level

after insert----row level
after delete--row level
after update--row level

after insert----statement level
after delete--statement level
after update--statement level

instead of trigger--row level
instead of trigger--statement level

Is This Answer Correct ?    15 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a schema? How is it useful in sql servers?

1119


How to read xml file in oracle pl sql?

913


What are three advantages to using sql?

1016


What is the difference between row level and statement level trigger?

1021


What is on delete restrict?

1000


How to fix oracle error ora-00942: table or view does not exist

1012


What is the difference between a procedure and a function?

1108


What are the query optimization techniques?

934


What is the file extension for sql database?

1000


How many types of cursors are available in pl/sql?

1108


What is sqlite used for?

997


what is single byte over head in oracle..?

2401


Does view contain data?

1029


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1034


Is like operator in sql case sensitive?

1022