how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 4885 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 |
can u plz provide me oca sql dumps please i need them
How do I learn what codesets are available in oracle?
Explain the dml?
How to define an oracle cursor variable?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
How to do paging with oracle?
What happens to the current transaction if a ddl statement is executed?
Is java required for oracle client?
Explain the use of consistent option in exp command.
Can multiple columns be used in group by in oracle?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Oracle General 
