Heterogeneous service (like Oracle or Ms SQL Server)
There is a concept of Database link?
Oracle Heterogeneous service (Trasparent gateway for ODBC) can create a link
to odbc database and the yuo can query 2 table across 2 different DB.
Select products.* , customer.name
from products, customer@accessdb
where products.id=customer.id
On Mon, May 12, 2003 at 06:19:49PM +0200, Mirco Tamburini wrote:
There is a concept of Database link?
Oracle Heterogeneous service (Trasparent gateway for ODBC) can create a link
to odbc database and the yuo can query 2 table across 2 different DB.
There is a dblink module in contrib that may do what you want.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
"the West won the world not by the superiority of its ideas or values or
religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
- Samuel P. Huntington