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 is execution plan in sql?
Compare sql & pl/sql
What does partition by mean in sql?
Why do we create views in sql?
What is vector point function?
What is diff between bulk collect and forall
Talk about views
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
What is the sql*loader? : aql loader
What type of join is sql join?
What is normalisation and its types?
What is clustered index sql?
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)