Batch file for Toad

it again give prompts that ask Commit or Rollback.

Add a commit at the end of your script and I think the prompt will go away.

If your goal is to just run some SQL and then exit Toad, you really should use the automation designer. It will really simplify your batch file, and you won't need EXIT or EXIT /B anymore.

I made a video of how to set it up and how to run it. I forgot to show in the video that you need to have the "save passwords" option in the login screen turned on.

As for learing materials, here are a few quick suggestions:

  1. Videos on Toadworld https://blog.toadworld.com/tag/toad-for-oracle-videos
  2. https://support.quest.com/toad-for-oracle/training
  3. Videos on youtube https://www.youtube.com/results?search_query="toad+for+oracle
1 Like