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


Please Help Members By Posting Answers For Below Questions

What is format trigger?

1618


How many categories of data types in oracle?

607


In what script is snap$ created? In what script is the scott/tiger schema created?

2251


How can we force the database to use the user specified rollback segment?

562


What are the different types of database objects?

530






Explain view?

582


what is normalisation?what are its uses?

1765


What is Segment Advisor in Oracle?

674


What are the predefined tablespaces in a database?

556


Can we insert data in view oracle?

543


What is query image?

586


What is background process in Oracle?

628


What is data type in oracle?

566


What is an oracle tablespace?

608


What do you mean by merge in oracle?

595