showdblinks.sql
DBリンク一覧を表示する
code:SQL
@column_format
col USERNAME for a10
col HOST for a35
col CREATED for a11
col VALID for a6
set lines 120
set timing off
select
OWNER
,DB_LINK
,USERNAME
,HOST
,to_char(CREATED,'yyyy/mm/dd') CREATED
,VALID
from ALL_DB_LINKS;
@default_settings