how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 5302 Views
- Value Labs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is Undo Management Advisor in Oracle?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
What is Read-Only Transaction ?
What is bind variable in oracle 11g?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What do you mean by merge in oracle and how can we merge two tables?
Explain oracle left join with an example?
What is oracle instant client?
What is trigger associated with the timer ?
Can you drop an index associated with a unique or primary key constraint?
What are the restrictions in a oracle read only transaction?
what is shell?
Oracle General 
