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
- 5937 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 |
Which is better Oracle or MS SQL? Why?
Why we choose emp number as primarykey?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is a cursor and what are the steps need to be taken?
What do you mean by redo log file mirroring?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
What is Read-Only Transaction ?
How to define a variable of a specific record type?
What are the built-in functions used for sending Parameters to forms ?
how to use sequence and what use of sequence cache
Why do we need integrity constraints in a database?
Oracle General 
