Topic: Changeable name of the table/representation in IG or IR
There are many databases and it is necessary to return from all the same request. I.e. to each DB there is a link and over it representation is created.
For example, DB1_REPORT as SELECT * FROM REPORT@DB1; DB2_REPORT as SELECT * FROM REPORT@DB2 and so on.
Whether it is possible to make the same page with interactive grid (or report) for all such representations? I.e., for example, there is a list of a DB and at values IG is updated?
I tried in IG in SQL Query to deliver value of an element of the list of a DB (using: or), but it did not turn out.
Or can eat any absolutely other decision for such problem? It is a lot of databases, but requests same. How it is better in APEX' to make it?