Views

Hi,
Here is a small script . Hope it helps.
set head off
set pagesize 0
set feedback off
set long 5000
col text word_wrapped
spool ddlview.lst
select ' Create or replace view ' || owner ||'.' ||view_name || '  as ( ' ,text ,');'
from dba_views
where owner='<Owner';
spool off
set pagesize 14
set pause on
set head on

          Shreepad.vaidya Received on Wed Jun 28 2000 - 00:33:50 CDT