Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

rows into columns

 
Phillipe Rodrigues
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic