1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / swapna

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / 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

More SQL PLSQL Interview Questions

Which sql statement is used to delete data from a database?

0 Answers  

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

What is Referential Integrity?

3 Answers  

What is cost in sql execution plan?

0 Answers  

What is view? Can we update view

0 Answers  




When are we going to use truncate and delete?

0 Answers  

Which query operators in sql is used for pattern matching?

0 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

What is scope and visibility in PL/SQL?

0 Answers  

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

What is a primary key? Explain

0 Answers  

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories