VIewObject based on 'pivot query'

I have seen few posts in ADF discussion forums asking for solutions to transpose database table rows in to columns. Apparently, this turns out to be s a query related to the underlying RDBMS. Attaching a simple demo application that transforms Employee Table in columnar from as shown below.

[If you use Oracle 11g, pivot operator will help you to achieve the same behavior. The above sample is not using pivot operator]
You can download the sample workspace from here.
[Runs with Oracle JDeveloper 11g R1 PS1 + HR Schema]

Comments

This comment has been removed by the author.
How about Entity based view object which has unsaved cache changes ?

Disclaimer

The views expressed on this blog are my own and do not necessarily reflect the views of my employer.