how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 4862 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 are the database administrators utilities available?
What is a static data dictionary in oracle?
Can a formula column referred to columns in higher group ?
How to experiment a data lock in oracle?
How to rename a tablespace in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
Why is oracle so popular?
What are the restrictions on external table columns?
Tell me New Feature of Oracle 10g?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the use of system.effective.date variable in oracle?
How to delete all rows a table in oracle?
Oracle General 
