how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 5422 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 |
How to use "in" parameter properly?
What is a table index?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What do you mean by group by clause?
Explain integrity constraints?
What is a schema in oracle?
Explain the truncate in oracle?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
What is an oracle database table?
what is IDE,DMV in sql server?
Explain how you would restore a database using RMAN to Point in Time?
Oracle General 
