4 Replies Latest reply: Nov 11, 2013 6:06 AM by BluShadow Branched to a new discussion. RSS

    Need help to construct a Query

    937357

      Hi Experts,

       

      Could you please helme to get required output.

       

      Input:

      select 'r1 * c1' Col1,'r1 * c2' Col2,'r1 * c3' Col3, 'r1 * c4' Col4 from dual union all

      select 'r2 * c1' Col1 ,'r2 * c2' Col2,'r2 * c3' Col3,'r2 * c4'Col4 from dual

      Output:

       

      TEST

      TargetCol 1Col 2Col 3Col 4
      Row 1r1 * c1r2 * c1r1 * c3r2 * c3
      Row 2r1 *c2r2 * c2r1 * c4r2 * c4

       


      Thanks in Advance.

       

      Regards

      Cheers.