1. Forum
  2. Usenet
  3. COMP.DATABASES.ORACLE.MIS

  • sqlplus : How to turn off output to terminal ?

    From [email protected]@21:1/5 to Atif Ahmad Khan on Fri Oct 6 14:41:42 2017
    On Friday, February 28, 1997 at 3:00:00 AM UTC-5, Atif Ahmad Khan wrote:
    How do I turn off output to terminal sqlplus from a select statement when I am spooling the result to a text file ?

    I have tried echo off, feedback off etc. but nothing seems to work.
    The problem is not easy to handle when the result is huge and I am
    over a modem connection.

    Thanks.

    Atif Khan
    [email protected]


    This is interesting topic. I found it today. hope it is useful.
    sqlplus "%usr_name%/%pass%@%db" @sqlscript.sql > suppressed.out

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Suntan@21:1/5 to suhong.it on Wed Oct 11 21:46:00 2017
    XPost: comp.os.vms

    On Fri, 06 Oct 2017 14:41:42 -0700, suhong.it wrote:

    On Friday, February 28, 1997 at 3:00:00 AM UTC-5, Atif Ahmad Khan wrote:
    How do I turn off output to terminal sqlplus from a select statement
    when I am spooling the result to a text file ?

    I have tried echo off, feedback off etc. but nothing seems to work. The
    problem is not easy to handle when the result is huge and I am over a
    modem connection.

    Thanks.

    Atif Khan
    [email protected]


    This is interesting topic. I found it today. hope it is useful. sqlplus "%usr_name%/%pass%@%db" @sqlscript.sql > suppressed.out

    As Suhong said, run it as a batch command with redirected output. If
    you need to, you can check on progress by connecting periodically and
    doing "tail -f suppressed.out". If you don't know if a result will be
    huge, connect via a utility or system that can junk terminal output yet
    still allow a "spool wanted.out". In an academic environment you may
    have VMS. Connect through VMS and type Ctrl-O (a second one resumes o/p).

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From VAXman-@21:1/5 to Suntan on Wed Oct 11 22:33:46 2017
    XPost: comp.os.vms

    In article <[email protected]>, Suntan <[email protected]> writes:
    On Fri, 06 Oct 2017 14:41:42 -0700, suhong.it wrote:

    On Friday, February 28, 1997 at 3:00:00 AM UTC-5, Atif Ahmad Khan wrote: ------^^^^^^^^^^^^^^^^^^^^^^^^^^

    Dr. Tony Newman and Dr. Doug Phillips have once again been transported
    through time via The Time Tunnel.

    --
    VAXman- A Bored Certified VMS Kernel Mode Hacker VAXman(at)TMESIS(dot)ORG

    I speak to machines with the voice of humanity.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Suntan@21:1/5 to VAXman- on Sat Oct 28 19:44:15 2017
    XPost: comp.os.vms

    On Wed, 11 Oct 2017 22:33:46 +0000, VAXman- wrote:

    In article <[email protected]>, Suntan
    <[email protected]> writes:
    On Fri, 06 Oct 2017 14:41:42 -0700, suhong.it wrote:

    On Friday, February 28, 1997 at 3:00:00 AM UTC-5, Atif Ahmad Khan
    wrote:
    ------^^^^^^^^^^^^^^^^^^^^^^^^^^

    Dr. Tony Newman and Dr. Doug Phillips have once again been transported through time via The Time Tunnel.

    VAXman yes, only saw that afterwards. (No idea how such an old post
    crept in).

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)