Hello Fellow bloggers,
With APEX 5.2 you get a lot of new options within your classic report one of them is : PL/SQL Function Body returning SQL Query.
With that function it’s easier than ever before to create dynamic classic reports.
Let me show you how.
Create a table where you store your query you want to use in your Classic report.
In your Classic Report Select :
Source Type = PL/SQL Function Body returning SQL Query
And there you have it.(DEMO)