how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 4858 Views
- Value Labs, I also Faced
- E-Mail Answers
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
What are the advantages of oracle 12c?
List out the difference between commit, rollback, and savepoint?
what is port in oracle? how is it related to database application.
How can we find out the current date and time in oracle?
Differentiate between function and procedure in oracle.
What is the Tune Query
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to define an anonymous procedure with variables?
How to view all columns in an existing table?
How can we create the complete backup of data in the oracle.
What happens if variable names collide with table/column names?
How to select some rows from a table in oracle?
How to shutdown your 10g xe server from command line?
What happens to the indexes if a table is recovered?
What is the data pump export utility?
