1 2 Previous Next 18 Replies Latest reply: Jul 5, 2007 11:04 AM by Alessandro Rossi RSS

    how to display empno in a single row instead of displaying it vertically

    223127
      Hi All,
      Greetings!

      Requirement :
      A select statement to display empno horizontally instead of vertical display at sql prompt.
      For Eg:

      SQL> Select empno from emp;
      empno
      --------
      9999
      2222
      3333
      4444
      5555
      ...
      ...
      ...
      ...

      Instead want the display of data in the below format

      empno
      ----------
      9999,2222,3333,4444,5555..........

      Thanks in advance.

      Regards,
      Naveen.
        1 2 Previous Next