In 17GA, I regularly have some one-off scripts to run. Some of the more complex ones require me to verify the results of one step before continuing to the next, and some of those have several steps. I've been executing these in separate tabs, but I'd prefer to do them all in one to get them all in the same transaction, as a failure in step 4 would generally warrant a rollback of the previous steps.
Enter the "PAUSE" SQL*Plus emulated command in an F5-able script, which almost fits the bill. The only issue is its modal popup doesn't let me validate the output of the previous commands, which requires me to scroll up (many) lines in the Script Output window.
Thoughts on how one might do what I want to do here?
You could use Toad's Script Debugger facilities, which gets you pretty close to what you want, I think. Snap One shows how to toggle on the mode, and Snap Two shows how my script can be stepped into (line by line, skip lines, run-to-cursor, etc.) and still allows me to FIND stuff in the script output right then and there between the lines... don't have to mess with PAUSEs any more.
