Results 1 to 3 of 3

Thread: turn off sql

  1. #1
    Join Date
    Jun 2006
    Posts
    20

    Unanswered: turn off sql

    is there anyway to turn off sql going to spool file ?
    i just need the query out put not the query itself.
    TIA.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    set echo off
    set feedback off

    then run sqlplus in silent mode (be sure to add EXIT at the end of your sql script):

    sqlplus -s username/password@sid @script.sql
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you don't issue a spool command.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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