spool all_link.rslt 
 
SET linesize 130;
SET pagesize 1000;
SET LONG 50;
SET echo ON;
 
break ON "OWNER" ON "TBL - NAME";
 
SELECT      SUBSTR(owner,1,10)                      "OWNER",
        SUBSTR(db_link,1,40)                    "LINK",
        SUBSTR(host,1,50)               "HOST",
     created                         "CREATED"
FROM      all_db_links 
ORDER BY 1 ASC, 2 ASC;
 
SET echo off;
spool off;
SET LONG 80;
COMMIT;