How do you use trigger to create mutating state of table




Answers were Sorted based on User's Feedback



How do you use trigger to create mutating state of table..

Answer / viswanath

Mutating State of a table happens when the trigger on top a
table tries to perform any DML operation on the same table
itself.

Is This Answer Correct ?    8 Yes 2 No

How do you use trigger to create mutating state of table..

Answer / pravin

Mutating state means changing or processing state, so when
you performed some manipulating operations from trigger or
write trigger for insert/update or delete on table it will
create mutating state of table.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer




More Oracle AllOther Interview Questions

can we drop dual table

7 Answers   Metric Stream,


What is the difference between oracle media recovery and crash recovery?

0 Answers  


Where would you look for errors from the database engine?

2 Answers   Fintellix,


What is supporting issues GL AP and AR?

0 Answers   Oracle,


what is sql*loader parameters and where we will use it.

1 Answers   Accenture,






what is difference between inner join & nested query or subqueries

0 Answers  


Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  


how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,


wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,


what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  


What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1658)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (188)
  • 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 (509)
  • 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)