/* ************************************************ */
/*                                                  */
/* Author            : Rick Kupcunas                */
/*                   : rick@kupcunas.com            */
/* Name		     : show_vw.sql                  */
/* Original          : 2002-May-05                  */
/*                                                  */
/* This script will Shows data for a given view     */
/*                                                  */
/* @C:\rkupcuna05_ora\Oracle\SQL\show_vw.sql        */
/*                                                  */
/* ************************************************ */

spool show_vw.rslt;

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

select owner "OWNER",
   view_name "VIEW",
                substr(owner, 1, 9) "USERNAME",
                text_length,
                text
       from     sys.dba_views
       where    view_name = upper('&&VIEW_NAME');
spool off;
undefine VIEW_NAME;
