how can we write trigger in trigger????????
can we write one trigger on two table???

Answers were Sorted based on User's Feedback



how can we write trigger in trigger???????? can we write one trigger on two table???..

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

how can we write trigger in trigger???????? can we write one trigger on two table???..

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

Post New Answer

More Oracle General Interview Questions

How to use "in" parameter properly?

0 Answers  


What is a table index?

0 Answers  


Which dictionary tables and/or views would you look at to diagnose a locking issue?

0 Answers  


What do you mean by group by clause?

0 Answers  


Explain integrity constraints?

0 Answers  


What is a schema in oracle?

0 Answers  


Explain the truncate in oracle?

0 Answers  


Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  


can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,


What is an oracle database table?

0 Answers  


what is IDE,DMV in sql server?

0 Answers  


Explain how you would restore a database using RMAN to Point in Time?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)