This discussion is archived
8 Replies Latest reply: Feb 8, 2013 5:09 AM by user522961 RSS

spool without query

user522961 Newbie
Currently Being Moderated
Hi,
on 11g , when spool to a file, query appears.
How to spool so that query text do not appers ?
I need just the lines returned.
Thank you.
  • 1. Re: spool without query
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

    Please review:
    Spool without query

    Regard
    Helios
  • 2. Re: spool without query
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Set Echo Off
  • 3. Re: spool without query
    Mark D Powell Guru
    Currently Being Moderated
    Besize the sqlplus set echo command osama mentioned you might want to check into some of the other SQLPlus set options such as "set feedback off" to eliminate the number of rows returned line, set linesize n to prevent line wrapping, set pagesize 0 to prevent page breaks with headers, and set trimspool on to eliminate trailing blanks on lines making the spool file smaller.

    HTH -- Mark D Powell --
  • 4. Re: spool without query
    user522961 Newbie
    Currently Being Moderated
    Thanks to all.
    Where to check into all of the SQLPlus set options ?

    Regards.
  • 5. Re: spool without query
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    startup sqlplus and run the command :
    SHOW ALL
    to view all the sqlplus settings.

    See the documentation :
    http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve040.htm#BACGAJIC



    Hemant K Chitale
  • 6. Re: spool without query
    EdStevens Guru
    Currently Being Moderated
    user522961 wrote:
    Thanks to all.
    Where to check into all of the SQLPlus set options ?

    Regards.
    =================================================
    Learning how to look things up in the documentation is time well spent investing in your career. To that end, you should drop everything else you are doing and do the following:

    Go to tahiti.oracle.com.

    Drill down to your product and version.

    <b><i><u>BOOKMARK THAT LOCATION</u></i></b>

    Spend a few minutes just getting familiar with what is available here. Take special note of the "books" and "search" tabs. Under the "books" tab (for 10.x) or the "Master Book List" link (for 11.x) you will find the complete documentation library. Including the SQLPlus Reference Manual.+

    Spend a few minutes just getting familiar with what <b><i><u>kind</u></i></b> of documentation is available there by simply browsing the titles under the "Books" tab.

    Open the Reference Manual and spend a few minutes looking through the table of contents to get familiar with what <b><i><u>kind</u></i></b> of information is available there.

    Do the same with the SQL Reference Manual.

    Do the same with the Utilities manual.

    You don't have to read the above in depth. They are <b><i><u>reference</b></i></u> manuals. Just get familiar with <b><i><u>what</b></i></u> is there to <b><i><u>be</b></i></u> referenced. Ninety percent of the questions asked on this forum can be answered in less than 5 minutes by simply searching one of the above manuals.

    Then set yourself a plan to dig deeper.
    - Read a chapter a day from the Concepts Manual.
    - Take a look in your alert log. One of the first things listed at startup is the initialization parms with non-default values. Read up on each one of them (listed in your alert log) in the Reference Manual.
    - Take a look at your listener.ora, tnsnames.ora, and sqlnet.ora files. Go to the Network Administrators manual and read up on everything you see in those files.
    - When you have finished reading the Concepts Manual, do it again.

    Give a man a fish and he eats for a day. Teach a man to fish and he eats for a lifetime.

    =================================
  • 7. Re: spool without query
    Mark D Powell Guru
    Currently Being Moderated
    Sorry I had intended to include a link to the SQLPlus manual in my post but just forgot to include it. Ed took care of that. -- Mark --
  • 8. Re: spool without query
    user522961 Newbie
    Currently Being Moderated
    really thanks to all.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points