How do you use trigger to create mutating state of table

Question Posted / pravin

2 Answers
7179 Views
TCS, I also Faced
E-Mail Answers

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

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers Pathway Technologies,

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers Wipro,

What is the mandatory setup in cyclecount ?

0 Answers Oracle,

which one is currently in used software cmpanies.

0 Answers

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers Cap Gemini, Syntel,

Explain the payment term in ar. : oracle accounts receivable

0 Answers

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

0 Answers

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers

How can you enable a trace for a session?

2 Answers

For more Oracle AllOther Interview Questions Click Here