Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    47

    Unanswered: table formatting

    i want to select all the rows of a table with the column header appearing fully. it must be restricted to the data length

    i.e. full column heading along with the data should be displayed.

    thanx in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: table formatting

    Originally posted by sundarr123123
    i want to select all the rows of a table with the column header appearing fully. it must be restricted to the data length

    i.e. full column heading along with the data should be displayed.

    thanx in advance.
    Do you mean in SQL Plus? If so, there are various formatting commands you can use like:

    COLUMN empno FORMAT 999999
    COLUMN ename FORMAT A30

Posting Permissions

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