3 Replies Latest reply: Nov 16, 2012 4:48 PM by JV123 RSS

    SQL qstn

    JV123
      Hi,

      Below SQL is displaying values in multiple columns but I want to diaplsy it as single column multiple rows.

      SELECT 'ALL','180',270',365' FROM DUAL.

      Result:
      ------------
      All
      180
      270
      365



      Thanks
      Jay.