Results 1 to 4 of 4

Thread: sppoling output

  1. #1
    Join Date
    Jan 2002
    Posts
    77

    Unanswered: sppoling output

    I want to spool the output from the following query to a file

    select * from v$tablespace;

    But when I spool to a file, and I open I see the command and the file. is there anyway, I can just get the output without the command.

    Your help is greatly appreciated

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    I seem to remeber its one of the SET xxx commands.

  3. #3
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    22
    you need to use

    SET TERMOUT ON

    this ensures you see any output

    To hide the commands that you type

    SET ECHO OFF

    make sure you use SPOOL OFF at the end

  4. #4
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    you may also want to use set hea off (ie set the header off-the column titles) and set pagesize 0 so it doesn't break the data up...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •