Dynamic Pivot table using PL/SQL

Recent project requirements had presented us with a scenario where the population had informational columns that varied on a per person basis, when the population changed the columns would change. Pivot table appeared to be the best option, but we need to respond to the requirements. To further complicate things this was for a real-time web application. So it needed to be fast.So after some scanning, found the following information, which allowed us to build a prototype. more »
Categories: OracleSQL
PermalinkPermalink