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
- 6030 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 a database is related to tablespaces?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
Explain about functional dependency and its relation with table design?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
what are pseudocolumns?
What are the different types of partitions in oracle?
How to create an initialization parameter file?
Explain an index?
How many anonymous blocks can be defined?
Oracle General 
