![toad for oracle unleashed toad for oracle unleashed](https://i.ytimg.com/vi/NX6LWZaCNZg/maxresdefault.jpg)
There are options to enable each script to spool out etc, feel free to examine the options button, on the top button bar above the connections window. The icon is a green arrow head with PL/SQL in text beside it.Īfter a short delay, the script(s) will have been run against all the databases you chose, and the results are at the bottom of the screen. To run the scripts against the database connections listed, go back to the button bar at t he top of the connections half of the screen, and click the first button. When you have added all your scripts, you can change the order in which they will run etc. If you forgot to add some other scripts, then just above the list of scripts in the bottom half of the screen, you will see a button to add more. make it descriptive, and you can, if desired, add a description too. You can add more using the 'ADD' button, or click the 'OK' button to stop adding, however, before you click the 'OK' button, you must enter a group name. The following dialogue shows the script you added. Navigate to the script you want and add it as desired. You then get to add one script in a following dialogue. It's the 4th one in, and looks like a blank sheet of paper with a "dog ear".įirst you must select a folder and then give the new file a name. When you have added all the desired databases, click the "new data file" button in the afore mentions button bar. Your current connection will be automatically added by the way - but you can remove it if necessary. First click the "add" on the far right of the list of connections to add further connections. Above this is a button bar - you'll need that later. In the top half of the screen, is a list of connections that you wish to run a/some scripts against. In the bottom, you will soon see some scripts, but first. There are two halves to the new window, the top and bottom. If you have already got a saved script (or scripts_ that you want to run, the skip this bit. In the editor, write your script, test it, and save it somewhere safe.