1

Topic: Changeable name of the table/representation in IG or IR

Greetings;
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?

2

Re: Changeable name of the table/representation in IG or IR

I can offer such decision, make one representation, select a column in which will be will be filled with a link title.
Thus at a shaft the request of such type turns out.

select * from all_views where db_link =:PXX_ITEM;

It is possible to save for example triggers instead of, or process written manually for IG.