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 varchar used for?

0 Answers  

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

What is the difference between a primary key and a clustered index?

0 Answers  

Define a temp table?

0 Answers  

how to create object in plsql

2 Answers   TCS,




Is sql difficult?

0 Answers  

How do I run sql profiler?

0 Answers  

Is sql microsoft?

0 Answers  

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

How do I run pl sql in sql developer?

0 Answers  

Which function is used to return remainder in a division operator in sql?

0 Answers  

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories