posted 15 years ago
Hi,
Request a query in oracle on how to convert rows into columns?
Reason being consider below example:
Table A:
Colunms: name, id
Values: john,1
shan,2
jimmy,3
table B:
Columns:id,roll no
1,23
2,24
3,25
Now the result displayed should be as below;
name name name rollno rollno rollno
John Shan Jimmy 23 24 25
Request your help.