This example shows how to load a script into SQL*Plus for the current session and execute it:

  1. Go into PM Options → Associations
  2. Remove SQL as an extension for SQL Editor (or anywhere else it may be)
  3. Click Add
    • Title: SQL Plus
    • Program: C:\oracle\ora92\bin\sqlplusw.exe
    • Working Dir: C:\oracle\ora92\bin
    • Parameters: $UID/$UPW@$SID @$FIL
    • Extension: SQL
  4. Click OK. The first Parameter block indicates a connect string for current TOAD session. The $FIL macro does a substitution for the underlying file. The @ is required by SQL*Plus to indicate script execution.
  5. Now add a Folder Item & browse to find a sample SQL script to execute. It will be added, and take on the SQL*Plus Icon.
  6. You can now double-click the item or right-click Load, and it will start up SQL*Plus for the current TOAD connection and execute the script.

About the Author

Steve Hilker

Steve Hilker was a Product Manager for Quest Software. Steve has over 35 years technical experience spanning application development, system administration, database management and various management positions at several software companies. Steve was the founder of RevealNet, best known for its desktop knowledge bases and unique database tools such as PL/Formatter. RevealNet was acquired by Quest Software in 2001. He's had the pleasure of being the product manager for many of Quest's database tools.

Start the discussion at