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 trigger?

Answer Posted / ashish

Triggers are stored procedures created in order to enforce
integrity rules in a database. A trigger is executed every
time when database modification done.
Triggers are executed automatically on occurance of one of
the data-modification operations.
A trigger is a database object directly associated with a
particular table. It fires whenever a specific
statement/type of statement is issued against that table.
The types of statements are insert,update,delete and query
statements.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle used for?

1031


How to start your 10g xe server?

1049


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1975


What is a sub query and what are the different types of subqueries?

1133


How would you change old and new values in an insert, delete and update triggers?

1027


 How to use an oracle sequence generator in a mapping?

1081


How to empty your oracle recycle bin?

1030


Explain a data segment?

1076


What is an oracle database table?

1020


What is materialized view in Oracle?

1078


1) Does oracle have any table which contain all the exceptions and it's code internally?

1758


How to write an inner join with the where clause in oracle?

1050


How do we represent comments in oracle?

1058


How can we find out the duplicate values in an oracle table?

1055


How is it different from a normal table?

1041