 | abouchez on Delphi: using IInterface to re… |
 | Peter Wright on Windows command prompt: decrem… |
 | Schalk Versteeg on How To Write Unmaintainable Co… |
 | dummzeuch on Do not make methods protected… |
| Peter Wright on LED Chaser with only 4017… |
Posted by jpluimers on 2016/09/27
I recently learned that you can do cross database queries in Oracle using database links.
You need to prefix your objects with the right schema/owner (for instance dbo.) and suffix with an @ sign followed by the database link name.
This query finds all configured database links:
select * from all_db_links;
–jeroen
via: Ask Tom “database link”.
This entry was posted on 2016/09/27 at 06:00 and is filed under Database Development, Development, OracleDB. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply