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;