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 >> Oracle >> Oracle General
  2. Suggest New Category

how many triggers we can create on a table

Question Posted / samir

Answer Posted / samir

You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.

You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.

Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.

This information is available in Books Online
under "Triggers".

Is This Answer Correct ?    5 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are actual and formal parameters?

1047

How do I escape a reserved word in oracle?

1126

How to upsert (update or insert into a table)?

950

How to invoke the data pump import utility?

1079

what is normalisation?what are its uses?

2205

Explain what are the different type of segments?

910

What is backup in Oracle?

949

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2205

What are oracle functions?

971

What is procedure overloading in oracle?

989

What types of joins are used in writing subqueries?

936

How to end the current transaction in oracle?

960

State the various uses of dbcc command?

986

what is a Nested Loop join?

2038

What is logical backup in oracle?

965