Oracle VM Site Review - Oracle VM Health Check
view counter

Cross Database Bridge Statement

Thanks to Dermot O'Neill for this story

Oracle allows you to query separate databases using Database Links.
You can even setup a Database Link in an Oracle database with a non Oracle database such as SQL Server or Sybase.

Oracle Virtualization and Cloud Consulting
view counter

Creating these types of Database Links can take some time, and sometimes you just want to reference a small bit of data on another Database and use it in your query.

SQL Developer allows you define connections to multiple databases including non Oracle databases. You can query each connection separately but until now you couldn't easily query different data sources (connections) at the same time in the one statement.

<img style="display: block; margin: 0px auto 10px; text-align: center; cursor: pointer; width: 400px; height: 238px;" src="http://4.bp.blogspot.com/_H4TtZUn_Tz8/TOb_BlidrAI/AAAAAAAAF_s/wKYex

Read the entire article at its source

view counter