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

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

What is group function in sql?

0 Answers  

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

What are the blocks in stored procedure?

6 Answers   Microsoft,

Can unique keys be null?

0 Answers  




How is pl sql different from sql?

0 Answers  

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

What is pessimistic concurrency control? : Transact sql

0 Answers  

What is the order of sql select?

0 Answers  

Is inner join same as self join?

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 field in a database ? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories