DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: To convert the column values into a row??

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    To convert the column values into a row??

    I am using oracle 9i or 10g
    Hi, plz help to write a single query,(not pl/sql)
    to display a column that consists values

    COLUMN - SNO
    1
    2
    3
    4

    the result should be a row 1,2,3,4

    with thanks

    gms

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    If you are haviong trouble with homework this simple, then you are in trouble when it gets harder.

    "SELECT rownum AS "COLUMN - SNO" FROM all_objects WHERE rownum <5;"

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492
    .
    And what have you coded to solve this homework assignment?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

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


Click Here to Expand Forum to Full Width