SQL Query to list all DB Links in a database

/*********************************************************
 *PURPOSE: Query to list all DB Links in a database      *
 *AUTHOR: Shailender Thallam                             *
 *********************************************************/
SELECT obj.object_type "Object Type",
  obj.owner            "Object Owner",
  obj.object_name      "Object Name",
  obj.status           "Object Status",
  dbl.db_link          "DB Link",
  dbl.username         "DB User Name",
  dbl.host             "DB Host"
FROM dba_objects obj,
  dba_db_links dbl
WHERE obj.object_name = dbl.db_link
AND obj.object_type   = 'DATABASE LINK';

/********************************************************* *PURPOSE: Query to list all DB Links in a database * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT obj.object_type "Object Type", obj.owner "Object Owner", obj.object_name "Object Name", obj.status "Object Status", dbl.db_link "DB Link", dbl.username "DB User Name", dbl.host "DB Host" FROM dba_objects obj, dba_db_links dbl WHERE obj.object_name = dbl.db_link AND obj.object_type = 'DATABASE LINK';