Wednesday, 2 September 2009

The Power of the Apex Repository

We all know about the apex views but hardly use them. Today, I answered two questions in the oracle Forum where the solution was related to the apex views. The first question was on how to create a report with all the csv links for all the reports in an application:

http://forums.oracle.com/forums/thread.jspa?threadID=952151

The second question was on how to provide a generic solution for a page help functionality:

http://forums.oracle.com/forums/thread.jspa?threadID=952469

Basically, the usage of apex views provides a simple two-step solution which doesn't require any maintanance.

In my demo application, you will find the corresponding examples:

Report on all csv links


Help page


Try it out.