rows into columns

[Phillipe Rodrigues]

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.

[Scott Selikoff]

While there may be some clever ways to do it in SQL, I don't think it should be done this way. You should save the records to local objects and transpose the columns and rows locally. This is a presentation issue and has nothing to do with JDBC.