pragma autonomous_transaction and we have to use commit also

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

Question Posted / a.v.r.murthy

Answer Posted / a.v.r.murthy

pragma autonomous_transaction
and we have to use commit also

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention what plvcmt and plvrb does in pl/sql?

1143

What is the difference between local variables and global variables?

1125

Why do we use sqlite?

979

how to create a table index in mysql? : Sql dba

1061

Why use truncate instead of delete?

1017

Is a table valued function object?

1023

Can you selectively load only those records that you need? : aql loader

1048

Is pl sql different from sql?

1001

what is union, minus and interact commands? : Sql dba

1186

how many columns can be used for creating index? : Sql dba

946

Is sql better than excel?

1155

Is a view faster than a stored procedure?

970

what's the difference between a primary key and a unique key? : Sql dba

1050

What is a trigger word?

1025

What is the use of sqlerrd 3?

944