DB Links

Query for getting DB Link name,password,username
========================================

set lines 1000
column Owner format a10
column DbLinkName format a30
column CONN_USER format a10
column CONN_PWD format a10
column CONN_STRING format a20

• select l.name DbLinkName , du.username Owner ,l.userid CONN_User, l.password CONN_Pwd, l.host Conn_String from sys.link$ l,dba_users du where l.owner#=du.user_id (+)
  

----Public Link will have Owner as Null

• select l.name Name , l.userid CONN_User, l.password CONN_Pwd, l.host Conn_String, l.ctime from sys.link$ l