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
- 5907 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 difference between postgresql and oracle?
Please explain drop constraint oracle?
How to test null values?
difference between bind variable and variable
How to generate query output in html format?
What is an oracle user account?
Can a property clause itself be based on a property clause ?
What is the difference between view and materialized view in Oracle?
How to use "out" parameter properly?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
What is an Oracle sequence?
What is oracle datasource?
Oracle General 
