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
- 5795 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 the use of composite key constraint?
How to insert a record into a table?
In Oracle 9i what does "i" Stands for?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
How to Select second Maximum salary in a Table ?
What are the factors causing the reparsing of SQL statements in SGA?
When do we use group by clause in a sql query?
How to put more than 1000 values into an oracle in clause?
Why oracle is used?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is index in Oracle?
Explain how are indexes update?
Oracle General 
