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 |
Give the order of sql select?
What are the different schemas objects that can be created using pl/sql?
What is sql resultset?
Can we create table inside stored procedure?
How delete all records from table in sql?
How to get each name only once from an employee table?
What is self-join and what is the requirement of self-join?
What is attribute indicator in pl sql?
what is meant by databases
what are the security recommendations while using mysql? : Sql dba
What is posting?
What is the plv (pl/vision) package offers?
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)