allmv.sql
code:SQL
--@allmv <MVNM-中間一致>
define MVNM=&1
set verify off
set timing off
@column_format
break on MASTER_LINK skip page
compute count of MVIEW_NAME on MASTER_LINK
set pages 70
set lines 200
set long 40
set longc 800
select
OWNER
,MVIEW_NAME
,QUERY
,UPDATABLE
,MASTER_LINK
,REWRITE_ENABLED
,REFRESH_MODE
,REFRESH_METHOD
from
ALL_MVIEWS
where MVIEW_NAME like upper('%&MVNM%')
order by
MASTER_LINK
,MVIEW_NAME
;
@default_settings