Many TOAD users ask “How can I run my SQL script against a collection or even all my databases all at once (i.e. in a single step)?” The problem is they generally ask this question while in the Editor – which by definition works with but a single active database connection at a time. But if you simply save the editor contents to a SQL script file – you can then use the TOAD Script Manager to execute that script against any number of databases at the push of a button. The BERT.SQL script highlighted below will create a DBA privileged account. Since Script Manager’s connection portion (top half of screen) shows three connections, when I press the toolbar “Execute” button (i.e. lightning bolt), this script will be run against my local 10g database, a remote server’s 10g database, and a remote servers 11g database. It does not get any easier than that. So please look into adopting the TOAD Script Manager amongst the features you routinely use.