how can we write trigger in trigger???????? can we write one trigger on two tab

how can we write trigger in trigger????????
can we write one trigger on two table???

Question Posted / krupananda08

2 Answers
5376 Views
Value Labs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we write trigger in trigger???????? can we write one trigger on two table???..

Answer / sudipta santra

No we can not attach one common trigger for multiple tables
but it is possible in vise-varsa.

Is This Answer Correct ?

2 Yes

0 No

how can we write trigger in trigger???????? can we write one trigger on two table???..

Answer / abhisudipta

Yes , I am again, my previous answer is correct only for the
2nd question.

In case of the 1st question: I would like to say that if we
use execute immediate in a procedure or function , there
write the script of creating the new trigger and then that
procedure/function is being called from the trigger body
then only it works.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer