aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Java class to perform Unpivot operator Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java class to perform Unpivot operator" Watch "Java class to perform Unpivot operator" New topic
Author

Java class to perform Unpivot operator

Dar Var
Ranch Hand

Joined: Oct 12, 2004
Posts: 74
Anyone know of a algorithm or Java class that can perform an unpivot operation on a ResultSet.

i.e. similar to Oracles Unpivot operator. See Example here

However I have to do this on the ResultSet returned. I can't do it in the sql.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19958
    
  25

Check out what ResultSet.getMetaData() returns and what you can retrieve from it.

Moving to JDBC.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: Java class to perform Unpivot operator