In many cases you might need to compare data between tables across different databases. For example your test instance and production instance.

You can easily create a database link between the 2 instances and be able to access the production data from the test database.

So if you created this link from Test to connect to the production database, you can now view data in the production instance from Test.

All you need to do is append an @Link_name at the end of the table name

For example

Thanks,

Zooz