Results 1 to 2 of 2

Thread: Spool options

  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: Spool options

    I have problem with spool data in SQL*plus!

    I need to export data from table in csv file. I create a query but when i go to sql*plus i need to enter
    spool ***.txt
    before i let qury to work. Now I get a text file in wich first is the syntax of the query and than resultats .

    What i really wont are only the datas with out any other text.
    HELLPPPP

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Spool options

    You need some SET commands in your SQL script before the SPOOL command, e.g.:

    SET FEEDBACK OFF
    SET PAGESIZE 0
    SET VERIFY OFF
    SET TERM OFF

    Then after the SPOOL OFF reset them:

    SET FEEDBACK ON
    SET PAGESIZE 20
    SET VERIFY ON
    SET TERM ON

    See SQL Plus docs for lots more SET commands you can use!

Posting Permissions

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