permaculture playing cards
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
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: 20128
    
  30

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java class to perform Unpivot operator
 
It's not a secret anymore!