Timeline for How to check if current SQL session has uncommited changes?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 5, 2019 at 11:04 | comment | added | Just a learner |
This will not work for transactions started with SET TRANSACTION READ WRITE NAME 'tran1';
|
|
| Aug 23, 2014 at 8:31 | comment | added | maxschlepzig | Hm, I am wondering how the Oracle SQL Developer program implement its uncommitted-transaction-check (while exiting)? I mean, it does not need extra privileges. | |
| Aug 15, 2014 at 9:34 | comment | added | kubanczyk | With one caveat. Select from @dblink would generate a dummy transaction with a bit of undo. It can be committed or rolled back without any impact. | |
| Aug 15, 2014 at 8:39 | history | answered | Balazs Papp | CC BY-SA 3.0 |