How do you view changes before committing when working in the Editor? (27254)

When working in the editor, an insert script is run successfully using F5. But when doing a quick select query to check the inserts just run, the changes to the data cannot be previewed. A commit is needed before it will be reflected in the query's results.

I would like to check my changes before committing.

To be able to view changes before committing:

RESOLUTION 1:

1. Run queries using F9, Execute as Statement, and view data in grid

RESOLUTION 2:

1. Go to View | Options | Oracle | Transactions
2. Enable option Execute scripts in Toad session

With this adjustment in the options you can now view data after using F5, Execute as Script, without committing.