I have complex queries(joins, unions, ...) and database where the query have to be executed. Databases are two. Problem is that I can't(I don't know how) add DB-Link to every table. All tables in one query are on same databese.
And now I search for something like:
insert into res_remote_table@dblink
select * from ( <complex_query_here> )@dblink
or another way to say where a query have to be executed without adding a dblink to every table.
I have queries,dblink, remote table name like varchar2. That means I hate to execute this with EXECUTE IMMEDIATE.