File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java class to perform Unpivot operator

 
Dar Var
Ranch Hand
Posts: 74
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20368
43
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out what ResultSet.getMetaData() returns and what you can retrieve from it.

Moving to JDBC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic