Hello

I have an Oracle Database and a DB2 database. I want to run a query connecting in Oracle database pulling some data from Oracle and some from DB2 in a single query. How can I do it.

Can I create a DB Link pointing to DB2. If not what would be a good way. I can connect to each database individually using ODBC but the problem is I can't connect to both databases together.

Thanks
Amit

Oracle LazyDBA home page