After Execute or Run, in the Query Console (or in opened file), query that doesn't need any commit or rollback, i.e. changes neither the database structure nor the data, it require commit/rollback.
Simple example: select * from dual;
So when you need to do some commit in another Tab, it simulate the commit but doesn't affect the database.
Now. to make real commit to the database, you need:
- find the Tab with required commit/rollback - that is challenge when you work with many tabs/files/consoles opened;
- do commit/rollback in that Tab;
- go back to the Tab with your code;
- do Commit.
It would be nice to have two things:
Visualize a tab in which the transaction is not completed (for example with color or symbol);
- Do not require the completion of the transaction in cases when do not change anything in the database.