Interested to Buy Any Domain ? << Click Here >> for more details...
How to come back in normal stage in Mutating Table if
mutating table is locked or update data?
- 2 Answers
- 6695 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 |
When we give SELECT * FROM EMP; How does oracle respond?
24 Answers Accenture, HCL, Infosys,
What is difference between table and view?
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
Why do we need cursors in pl sql?
how would you get the current date in mysql? : Sql dba
What is sql procedures and functions?
i have some prob lem to tell me about my self in interview first round ...
What is foreign key and example?
what is single byte over head in oracle..?
Which table is left in join?
What is difference between db2 and sql?
What is difference between joins and union?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
