rem rem Generate view creation script rem rem Biju Thomas rem rem Pass owner name and view name as parameters rem set heading off verify off feedback off arraysize 1 long 1000000 termout off set pages 0 lines 78 trims on column vtext format a78 wrap spool /tmp/crview.sql select 'create view '||owner||'.'||view_name||' as ',text,';' vtext from all_views where owner like upper('&1') and view_name like upper('&2') / spool off set termout on feedback on verify on heading on prompt prompt Output saved at /tmp/crview.sql prompt