Hello,
I have a multiple schema/DB in which there are consider 5 common tables. Also, I have a common query say like:
select t1.col, t2.col, t3.col from schema_name.table1 t1
inner join schema_name.table2 t2
inner join schema_name.table3 t3;
Here schema_name is same through a query with containing common tables in it, there can be multiple schemas but all having those same tables with same structure.
Now i have such a requirement that, User want an APEX page, on which there should be a select list consisting of those schema names on selection of it the common query should be executed and data should be displayed. My challenge here is how can i dynamically change the schema names of a query.
In any classic report or IG if we use the function returning sql option then it would be more of a manual work like we will have to write a block of query for every schema we would provide in the drop down,also if any new schema is added then again we will have to write a block of query for the new schema.
Please provide some better and reliable option.
Please feel free to reach out for any clarification on anything.
APEX Version- 22.2.5