set define on verify off long 200 lines 300 pages 400 feed off
col owner format a23 Head "Owner"
col username format a30 Head "Connects To"
col db_link format a38 Head "Database Link"
col host format a50 word_wrap Head "Connect Description"
col CREATED Head "Created"

SELECT owner, db_link, username, created, host
FROM dba_db_links
WHERE owner LIKE upper( '&1.' )

col host clear
col db_link clear
col username clear
col owner clear

PROMPT