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

Answer Posted / a.v.r.murthy

pragma autonomous_transaction
and we have to use commit also

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the differences between binary and varbinary? : Sql dba

720


What is pl/sql language case sensitive?

828


What is a primary key called that is made up of more than one field?

1029


What is the example of procedure?

678


What found sql?

703






What are triggers in sql?

749


What are the main features of cursor?

826


Does sql profiler affect performance?

733


What are operators available in sql?

786


Explain alias in sql?

770


what is the difference between a local and a global temporary table? : Sql dba

741


What is dense_rank in sql?

696


What is the use of sqldataadapter?

704


What is microsoft t sql?

678


how to use myisamchk to check or repair myisam tables? : Sql dba

711