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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy