allvw.sql
code:SQL
--@allvw <MVNM-中間一致>
define VWNM=&1
set verify off
set timing off
@column_format
col TEXT for a80
select
OWNER
,VIEW_NAME
,substr(TEXT_VC,1,200) TEXT
from
ALL_VIEWS
where OWNER = sys_context( 'userenv', 'current_schema')
and VIEW_NAME like upper('%&VWNM%')
;
@default_settings