How to create an interactive report using PL / SQL refcursor

I need to create an interactive report, but instead of running the sql statement, I need to run the pl / sql statement

-----------------------------------------------------------------------------
USER_ID        Name                 1 java 2 php 3 pl/sql / sql 4 Oracle apex
-------------- -------------------- ------ ----- -------------- -------------
3              Amy brown            N      N     Y              N           
4              Sarah woods          N      N     Y              Y           
2              Johnny paterson      Y      Y     Y              Y           
1              John brown           Y      N     Y              Y   

If this cannot be done on top, is there a way to save the results of this pl / sql statement in csv format when running pl / sql?

In an interactive report, users cannot add or remove anything. Its just for viewing.

thank

+3
source share

All Articles