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
- 5815 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 a data lock in oracle?
How to use subqueries with the exists operator in oracle?
What is TNS File
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
Does oracle charge for java?
Explain about integrity constraint?
What is object data modeling?
Can you use a commit statement within a database trigger?
Is oracle a language?
What is an Oracle index?
How do you handle duplicate records in a database?
Oracle General 
