How to come back in normal stage in Mutating Table if
mutating table is locked or update data?
- 2 Answers
- 6065 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / a.v.r.murthy
pragma autonomous_transaction
and we have to use commit also
| Is This Answer Correct ? | 0 Yes | 0 No |
What does seeding a database mean?
How do you explain an index number?
What is Difference Between Unique and Primary Key Constraints?
What is integrity in sql?
How to run sql statements with oracle sql developer?
How can we link a sql database to an existing android app?
What is sql server and ase?
What are the components of a PL/SQL block ?
What is assignment operator in pl sql?
What is the basic structure of an sql?
how to shutdown mysql server? : Sql dba
What is trigger in flip flop?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
