Re: multiple databases
Hi Mike,
You need to use the full table specification in your queries. The database name has to be specified before the table name (such as my_db.my_table).
For instance, this SQL syntax example aggregates data from different tables and databases:
SELECT t1.*, t2.* FROM db1.tab1 t1, db2.tab2 t2 WHERE t1.id = t2.id
Subject
Written By
Posted
Re: multiple databases
July 28, 2019 08:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.