Tags: command, commands, database, drives, file, guys, mysql, oracle, serveroutput, spool, sql, toad
How to use SPOOL command in TOAD
I need to know how to use SPOOL & set serveroutput on commands in TOAD, to spool the file to drives.
Thanks in advance...
Leave a comment...
- 5 Comments
- These are SQL*Plus commands, not TOAD commands.#1; Sat, 23 Feb 2008 15:37:00 GMT
- For getting the dbms_output in Toad, in SQL Editor window, in the lower pane there is a table "DBMS Output", you can go to that tab and click the green button there, to get the outputs of dbms_output.
Alternatively you can also find the dbms output window, through View->DBMS Output
For spooling the output, there is something in toad to spool output to screen/file, using Tools->Spool SQL->Screen/File, but I am not sure how it works#2; Sat, 23 Feb 2008 15:38:00 GMT
- From TOAD's help file:
Database|Spool SQL command will either display all SQL to message boxes on screen or send it to a file (\temps\debug.sql) depending on your choice from the menu.
To spool SQL effectively
Select Database|Spool SQL and where you want to send the code (to Screen or to File).
Select a function from Toad. The SQL Toad used to perform that task is spooled to either the screen or the specified file. For more information on Spool SQL to Screen, see Output Window.#3; Sat, 23 Feb 2008 15:39:00 GMT
- In SQL EDITOR. right click and
Desktop Panels and Select DBMS OUPPUT.
Then at the Bottom
select DBMS Output tab and turn it on To display the out put.( from Red ) it will tunr in to Green
null#4; Sat, 23 Feb 2008 15:40:00 GMT
- TOAD tries to mimic SQL*Plus. For example, the following works for me if I select 'Run as a script' in TOAD:
SET LINESIZE 150;
SET PAGESIZE 0;
set heading off echo off feedback off;
where owner = 'SCOTT';
set heading on echo on feedback on;
-cf#5; Sat, 23 Feb 2008 15:41:00 GMT