Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java class to perform Unpivot operator

 
Dar Var
Ranch Hand
Posts: 74
  • 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: 20526
54
Chrome Eclipse IDE Java Windows
  • 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.
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic