Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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: 20753
68
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic