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


Please Help Members By Posting Answers For Below Questions

How to use "startup" command to start default instance?

515


How does oracle handle read consistency?

654


What is bulk load in oracle?

570


What is archive log in Oracle?

574


What are the different types of synonyms?

564






What is a user account in oracle?

600


what is reindexing?

1149


What is the usage of synonyms?

557


How to write date and time literals in oracle?

535


What is the Tune Query

1814


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

525


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

1558


how do u setup a replication site?

1474


What is system global area (sga) in oracle?

547


How to count duplicated values in a column in oracle?

524