allsynnl.sql
code:SQL
--@allsynnl <SYNNM-中間不一致>
define SYNNM=&1
set verify off
set timing off
@column_format
select
OWNER
,SYNONYM_NAME
,TABLE_OWNER
,TABLE_NAME
,DB_LINK
from
ALL_SYNONYMS
where OWNER = sys_context( 'userenv', 'current_schema')
and SYNONYM_NAME not like upper('%&SYNNM%')
order by
TABLE_OWNER
,SYNONYM_NAME
;
@default_settings