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 |
how to convert character strings to dates? : Sql dba
What are the types of index in sql?
How do I run a sql script?
How to get each name only once from an employee table?
How to add Foreign key in a table after the creation of the table?
Do we need to create index on primary key?
Is it possible to access the current value in a session before accessing next value?
What is execute immediate?
Can we write ddl statements in functions?
how many triggers are allowed in mysql table? : Sql dba
Does pl/sql support create command?
What is difference between % ROWTYPE and TYPE RECORD ?
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)