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
- 5929 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 |
How to execute the package in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
what is port in oracle? how is it related to database application.
Define 'view' advantage ?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What is the difference between truncate & delete command?
How is it different from a normal table?
Why packages are used in oracle?
How to get a list of all background sessions in the database?
What is a relational database management system?
How to define a procedure inside another procedure?
Oracle General 
