-- name       : db_links.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show database link details
-- limitation : needs access to dba_db_links
--
-- useage     : SQL> @db_link

set pages 50
set feed off
set verify off
set linesize 200

spool db_links.lis

col owner head "Owner" for a10
col db_link head "Link" for a20
col username head "Username" for a10
col host head "Host" for a30

select 	owner owner,
	db_link db_link,
	username username,
	host host
from dba_db_links
/

spool off

set pages 24
set feed on
set verify on
set lines 80