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 a trigger and types of triggers

Answer Posted / anitha

A trigger is a set of actions that are run automatically when a specified change operation is performed on a specified table. The change operation can be an SQL INSERT, UPDATE, or DELETE statement, or an insert, update, or delete high level language statement in an application program
types of triggers.
• Before delete trigger
• Before insert trigger
• Before update trigger
• After delete trigger
• After insert trigger
• After update trigger
• Read only trigger (external trigger only)

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 use of dclgen in db2?

1085


How will you return the number of records in table?

937


What are the contents of dclgen?

1112


What is bind in db2?

1042


What are types of indexes?

1071


What types of tables are there in the db2 database?

1055


List down the data types in the db2 database.

1123


What is dbrm? When it will be created?

1029


Where can you declare a cursor in a cobol-db2 program?

1077


Why select is not preferred in embedded sql programs?

1299


What r the comman abends in db2, jcl and cobol???????

2252


What is cloudant database?

1096


Define check constraint.

1076


What is the difference between cursor and select statement?

1100


How do we specify index to include or not during bind process.

2126