Re: How to drop all views or tables?

In article <1992Oct27.193408.5234_at_gdstech.grumman.com> un_at_gdstech.grumman.com (Un Fu) writes:
>Does anyone know how to drop all views or tables belong
>to a particular user by the particular user (say me)?
>The 'DROP VIEW ...' and 'DROP TABLE ...' commands can
>only remove one view or one table at a time.
>
>Thanks in advance for any help!
>
>--
>****************************************************************************
>Un Un Fu Internet: un_at_gdstech.grumman.com
>Disclaimer: I am solely responsible for what I am saying here!
>****************************************************************************

set head off
set pagesize 0

spool drop.sql

select 'drop table '||table_name ||';'
from user_tables where owner = '&owner_name';

spool off

start drop.sql

exit Received on Wed Oct 28 1992 - 21:41:36 CET