how many triggers we can create on a table
Answer Posted / karthikeyan.v
You can create a maximum of 12 triggers on a table
3*2*2=12
insert/delete/update3
before/after2
row/statement-2
Is This Answer Correct ? | 95 Yes | 13 No |
Post New Answer View All Answers
How to use "startup" command to start default instance?
How does oracle handle read consistency?
What is bulk load in oracle?
What is archive log in Oracle?
What are the different types of synonyms?
What is a user account in oracle?
what is reindexing?
What is the usage of synonyms?
How to write date and time literals in oracle?
What is the Tune Query
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
how do u setup a replication site?
What is system global area (sga) in oracle?
How to count duplicated values in a column in oracle?