Invoke SQL *Plus through Textpad

This will only benefit those people who use the product Textpad and SQL *Plus. If you wish to run SQL *Plus scripts direct through Textpad, you can set it up as follows:

In Textpad Navigate to:

Configure > Preferences > Tools

Add Program

Browse and Select sqlplus.exe

Click OK

Then navigate to:

Configure > Preferences > Tools > sqlplus

In the right-hand panel; In the field labeled "Parameters" add:

/nolog @$File

This will essentially invoke sqlplus /nolog and if the SQL script you have opened in Textpad contains the line:

connect username/password@database

You will be able to use a shortcut-key (in my case ctrl-1) to execute the SQL script directly on Textpad.