3 Replies Latest reply on Nov 16, 2012 10:52 PM by doginthesun

    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.