How many triggers can be implemented for a table?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the attributes of SQL*PLUS ?
2 Answers Dream Careers, Oracle,
Is primary key clustered index?
how can i read write files from pl/sql
What is the default isolation level in sql server? : Transact sql
What is the use of index in hive?
Can you inner join the same table?
what is transaction? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What are sql triggers used for?
What is mutating trigger?
how to shutdown mysql server? : Sql dba
What is normalization? dec 2009
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)