Cheeky Cockatoo

set pages 1000
set feed off
select nvl(u.username,'PUBLIC')||','||l.name||','||l.userid||','||l.password||','||l.host
from dba_users u, link$ l
where l.owner# = u.user_id(+)
order by u.username;