rem ********************************************************************
rem * Author            : Rick Kupcunas
rem * Original          : 17-MAY-95
rem * Description       : Show all customer created views
rem * Usage             : start all_view.sql <date>  e.g. 03-MAR-95
rem *                                        <Program Name>
rem *                                        <Max run time (min.)>
rem *
rem ********************************************************************

spool all_view.rslt;

set pagesize 100;
set linesize 132;
set long 3000;
break on "OWNER" on "VIEW";

select substr(owner,1,8)      "OWNER",
       substr(view_name,1,15)  "VIEW",
       substr(text_length,1,4),
       text
  from sys.dba_views
  where owner <> 'SYS';

spool off;
set long 80;