APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can we use Dynamic SQL query to create APEX classic reports?

3275770Aug 9 2016 — edited Aug 9 2016

Apex version-4.2

I have an apex page where i am including multiple reports. But the the user will come in and select a database name. on that basis the user will get reports on the performance,backups,sessions,etc related to the database he selected in the select list(Suppose page item P1_Dbname)

But the problem is the database name suppose is DB1 but for reports I have views named as DB1_Session,DB1_Backup,etc

So will be able to include a dynamic query for the report where i would be getting the Dbname from the page item P1_Dbname and then make it DB_Session or whatever and displat the select * from that view.

Also somebody suggested me using Apex collections for this? but i have no clue how to do that?