How to come back in normal stage in Mutating Table if
mutating table is locked or update data?

Answer Posted / swapna

You can use the PRAGMA Function.
I.e Autonomous Function to come back to normal stage in
Mutating table.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between blob and text? : Sql dba

730


What is nosql vs sql?

877


What is execute immediate?

720


Compare sql & pl/sql

773


Does google use sql?

707






Does mysql support pl sql?

811


What is data control language?

736


What is normalization sql?

724


Is it possible to link two groups inside a cross products after the cross products group has been created?

769


Is sqlite thread safe?

791


What are %type and %rowtype for?

808


Explain the advantages and disadvantages of stored procedure?

853


What is benefit of creating memory optimized table?

703


discuss about myisam index statistics collection. : Sql dba

696


when is the use of update_statistics command? : Sql dba

686