Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    98

    Unanswered: formatting sqlplus query result

    what's the command for getting rid of the


    '---------------------------'

    seperator when you do a query in sqlplus?

    TIA

    Mark

  2. #2
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    This separator comes with the heading.
    You can set the heading off and get rid of it..

    SQL>set heading off
    SQL>
    Oracle can do wonders !

  3. #3
    Join Date
    Jan 2004
    Location
    Issy les Moulineaux, France
    Posts
    24
    You can keep the heading without the separator with

    SQL> set underline off
    SQL>

    Eric.

Posting Permissions

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