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

Need help to construct a Query

937357 Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points