Can comments and queries be displayed in the Script Output tab of the SQL Editor Window when results from the queries are returned?
To display the SQL statements in the Script Output tab after execution, the following will need to be added to the statement prior to executing scripts:
SET SQLPROMPT "";
SET ECHO ON;
This can also be added to the glogin.sql file to auto execute the script upon connections.
Toad versions prior to 9:
1. Select View | Options | SQL Editor | Script Options.
2. On the right hand pane, select the "Edit File" button and add the above SQL*Plus command statement to the end of this file.
3. The "Execute login scripts" option will need to be enabled.
Attached is a sample of the glogin.sql file with the above command added.
Toad versions 9.0 and above:
1. Select View | Toad Options menu option
2. Select Execute/Compile from the left-side tree
3. On the right, under Login Script section, click on the Edit button next to glogin.sql file
4. Toad will open this file with Notepad
5. Go to the bottom of the file and copy/paste the below lines:
SET SQLPROMPT "";
SET ECHO ON;
6. Check the "Execute login scripts" check box
7. Hit OK to exit Options
8. Close, reopen Toad and reconnect to your database
