Query To Get List of Database Links

Download(dblinks.sql)

REM +======================================================================+
REM                    
REM File Name: dblinks.sql
REM 
REM Description:
REM   Query To Get List of Database Links 
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @dblinks.sql
REM   
REM +======================================================================+

clear columns
set lines 180
col OWNER for a20
col DB_LINK for a50 WORD_WRAPPED
col USERNAME for a20
col HOST for a30 WORD_WRAPPED

select * from dba_db_links;