list views with name like.sql

on June 23, 2008 at 12:39 pm
Posted In: Oracle DB Objects (tables, sql etc) (Cat)

set pause on
set pages 24
set pause ‘Any Key>’
spool vw_lst.lst
select view_name, owner from all_views where view_name like UPPER(nvl(‘&VIEW_NAME’,’WHOOPS’)||’%’)
/
spool off