how can we write trigger in trigger????????
can we write one trigger on two table???
Answer Posted / 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 |
Post New Answer View All Answers
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What are transaction isolation levels supported by oracle?
How many categories of data types?
How to use subqueries with the exists operator in oracle?
What is merge in oracle?
What is rowid and rownum in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
How to delete multiple rows from a table in oracle?
How to retrieve data from an cursor to a record?
How to loop through a cursor variable?
What is a sub query? Describe its types?
How to export your own schema?
How can we create the complete backup of data in the oracle.