spool all_link.rslt 

set linesize 130;
set pagesize 1000;
set long 50;
set echo on;

break on "OWNER" on "TBL - NAME";

/* ****************************************************** */
/*                                                        */
/*  - will show all the links for a given database        */
/*                                                        */
/*     @C:\rkupcuna05_ora\Oracle\SQL\all_link.sql          */ 
/*                                                        */
/* ****************************************************** */

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;









