Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Only select data in spool-file

    Hi,

    I want only the selected data in a spool-file (I use sqlplus 8.1.7 for AIX).
    But I still have the select query and the spool-msg in the spool file. Are there settings that I could use ?

    Willem



    "export ORACLE_SID=*****
    scriptSql=./$0.sql
    echo "spool listeOA;" > $scriptSql
    echo "select distinct ****** from *****;" >> $scriptSql
    echo "spool off;" >> $scriptSql
    echo "exit" >> $scriptSql

    sqlplus *********/****@$scriptSql"

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Set your environment variables in the SQL file you're running ...

    ie
    set space 0
    set pagesize 0
    set feedback off
    set verify off
    set termout off
    set heading off
    set serveroutput off
    set echo off
    set show off
    set trim off


    HTH
    Gregg

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    Thank you very much for your answer !

Posting Permissions

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