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 input buffer in sql*plus?

1290

How can I tell if sql is running?

1127

Is left join faster than join?

1096

Is it possible to create the following trigger: before or after update trigger for each row?

1348

define data blocks ? : Sql dba

1043

What is indexing in sql and its types?

1131

what are ddl statements in mysql? : Sql dba

1263

What is %rowtype in pl sql?

1029

What found sql?

994

What is a mutating table and a constraining table?

1178

What are the subsets of sql?

1194

What is having clause in sql?

1018

How to select unique records from a table?

1105

Is sql a case sensitive language?

1008

What is sql*loader and what is it used for? : aql loader

1247