how can I delete all views in my database in ONE step.
select 'drop view ' || owner || '.' || view_name
thanks very much,
I am using this settings to get red off the headings and
feedback and the rest of the junk, but it is not working !!
set heading off;
set feedback off;
set echo off;
set termout off;
set scan off;
I keep getting this
SQL> select 'drop table ' || table_name||';'
2 from user_tables
drop table test;
drop table test1;
well, as far as I know, you cannot prevent the query and the spool off from being in the spooled file ...
Click Here to Expand Forum to Full Width