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

What is db journal file?

1035

Why do you partition data?

1010

What is identity column in sql server?

1035

What is sap sql?

960

Is keyword pl sql?

963

what are the type of locks ? : Sql dba

944

What are system versioned tables?

1010

What is the difference between a database and a relational database?

1083

What is the difference between sum and count in sql?

973

What are different clauses used in sql?

1104

What is difference between pls_integer and integer?

939

Which version of sql do I have?

1036

What is minus?

973

What is sql analyzer?

996

What is difference between left and right outer join?

969