Script: db_links.sql

 -- -----------------------------------------------------------------------------------
       -- Author       : Pavan Yennampelli
    -- Description  : Displays information on all database links.
    -- Requirements : Access to the DBA views.
    -- Call Syntax  : @db_links
       -- -----------------------------------------------------------------------------------
    SET LINESIZE 150

    COLUMN db_link FORMAT A30
    COLUMN host FORMAT A30

    SELECT owner,
           db_link,
           username,
           host
    FROM   dba_db_links
    ORDER BY owner, db_link;