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

default triggers available for reports

0 Answers  


Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers   HCL,


what is difference between inner join & nested query or subqueries

0 Answers  


what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,






What view would you use to determine free space in a tablespace?

0 Answers  


HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  


types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

0 Answers   TCS,


What Are Cross Validation & Adi?

0 Answers   Oracle,


What command would you use to create a backup control file?

1 Answers  


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)