O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Dynamic Interactive Reports

We had seen that we can make a dynamic classic report by picking Function Returning SQL Query as the region source in the Dynamic query region in APEX section of Chapter 2, Conventional Reporting in APEX. We do not have this liberty in IRs, but we can use the table function using both native and interface approach and APEX collections to create dynamic reports in IR.

Let us first talk about the table function. It accepts a collection or a ref cursor and is used in the from clause of a query. The table function can be used as any other physical table. Two important features associated with a table function are pipelining and partitioning. We will see information about both of these in the coming sections. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required