Interested to Buy Any Domain ? << Click Here >> for more details...
how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 6025 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 oracle rowcount?
How to download oracle database 10g xe?
What is a nested table and how is it different from a normal table?
how to insert data into partitioned table partition done by Range partition
What is the difference between pre-select and pre-query?
how to find the second highest salary in a given table????
What is a Data File ?
What is the function of Redo Log ?
How can you Enforce Referential Integrity in snapshots ?
How many memory layers are in the shared pool?
How can I see all tables in oracle?
How to create a new table by selecting rows from another table?
Oracle General 
