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


How many triggers can be implemented for a table?

Answers were Sorted based on User's Feedback



How many triggers can be implemented for a table?..

Answer / msy

12 Trigger can be created on a single table.

Is This Answer Correct ?    5 Yes 1 No

How many triggers can be implemented for a table?..

Answer / nishi

Before oracle 10g 12 trigger possible after oracle 10g more than 12 trigger we can use

Is This Answer Correct ?    1 Yes 0 No

How many triggers can be implemented for a table?..

Answer / hairreddy

we can create more no of triggers on a single table but we can apply 12 different type of triggers only on a table
before -- for this table level and row level (insert/update/delete)-----total 6
after-- for this table level and row level (insert/update/delete)-----total 6

total 12 different triggers we can write on a table

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is difference between hql and native sql?

0 Answers  


mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  


how to extract a unit value from a date and time? : Sql dba

0 Answers  


i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,


What is a parameter query?

0 Answers  


What are procedures used for?

0 Answers  


how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  


What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  


Sql technical questions

0 Answers  


What will you get by the cursor attribute sql%notfound?

0 Answers  


What are the types of operators available in sql?

0 Answers  


What is trigger in sql and its types?

0 Answers  


Categories