Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: How to format the select output without any heading

    When I do the select in sql/plus, normally, output will be the following:

    col1
    ----
    1
    2
    3
    .
    .
    10

    col1
    ----
    11
    .
    .
    .
    .
    20


    How can I format the ouput look likes that:
    1
    2
    3
    4
    4
    .
    .
    .
    .
    20

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    set heading off;
    set pagesize 0;

Posting Permissions

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