Oracle Read - Oracle Blogs Aggregator

$ sqlplus scott/tiger@DEVL
SQL> select * from all_db_links;
no rows selected
SQL> select * from dual@PROD;
D
-
X

Hey, why does this work???
Ok, after some research I found out that this seems to be an implicit loopback database link. The fact that the DEVL database has the global name set to PROD is just to annoy more

SQL> select * from global_name;

GLOBAL_NAME
——————————–
PROD.LAURENTSCHNEIDER.COM