File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
rows into columns
Joined: Oct 30, 2007
Dec 14, 2008 09:07:00
Request a query in oracle on how to convert rows into columns?
Reason being consider below example:
Colunms: name, id
Now the result displayed should be as below;
name name name rollno rollno rollno
John Shan Jimmy 23 24 25
Request your help.
Joined: Oct 23, 2005
Dec 14, 2008 10:09:00
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
[OCA 8 Book]
I agree. Here's the link:
subject: rows into columns
How to parse string with separators
'A HREF = a row in Database' for each req_id in Servlets
How to update value using struts
sorting a resultset
How to give hyperlink to a row in a table which is XML data
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015