You can create a maximum of 12 triggers on a table 3*2*2=12 insert/delet

how many triggers we can create on a table

Question Posted / karthikeyan.v

11 Answers
52299 Views
G2 Technology, TCS, I also Faced
E-Mail Answers

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

Explain the use of indexes option in exp command.

1149

How to start your 10g xe server from command line?

1073

Explain a synonym?

1032

How to convert characters to times in oracle?

1023

Explain the use of control file?

1113

What happens to the current transaction if a ddl statement is executed?

1013

How to set a transaction to be read only in oracle?

1094

What are the differences between lov and list item?

1066

How do I uninstall oracle client from windows?

1011

What is the meaning of recursive hints in oracle?

1046

What is an oracle database?

1036

What is oracle instant client?

1024

What are the oracle differences between nvl and coalesce

1149

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

How to use an explicit cursor without open statements?

1055