Tags: command, commands, database, drives, file, guys, mysql, oracle, serveroutput, spool, sql, toad

How to use SPOOL command in TOAD

On Database » Oracle

1,843 words with 5 Comments; publish: Wed, 13 Feb 2008 20:54:00 GMT; (25046.88, « »)

Hi Guys,

I need to know how to use SPOOL & set serveroutput on commands in TOAD, to spool the file to drives.

Thanks in advance...

Bye

Mahi

All Comments

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:

      Spool SQL
      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;
      SPOOL U:\REC_COUNT.SQL
      select table_name
      from all_tables
      where owner = 'SCOTT';
      spool off;
      set heading on echo on feedback on;

      -cf

      #5; Sat, 23 Feb 2008 15:41:00 GMT