I recently upgraded from toad 10 (10.5.0.41) to 12 (184.108.40.206). There are several things I used to do in TOAD 10 and I cannot seem to find the correct settings to mimic this behavior in 12.
In 10, I would open an editor, and I could run a basic update statement:
update table1 set type=1 where id between 1 and 10;
Then I could view it in the same query window
select * from table1 where id between 1 and 10;
At this point I would review the data and determine if I wanted to commit or rollback. In TOAD 12, I cannot do this. It is showing me the original data without the changes. I am in the same editor window. In the old one, if I went to a different editor window it also would not have the changes. Only in the window where I made the change would I be able to see the changes. This was an extremely handy feature… I have tried to compare my settings between 10 and 12 several times, but I have not been able to find anything. It seems it would tie to executing queries in threads, and I do have that turned on:
Thank you in advance for any advice.