Re: Cursor to drop all tables

I think (I do not have my books, cause I am on the road) that the problem here is related to dynamic SQL.

The method I use for this purpose is to use a tool like Golden,SQL Worksheet or EZSQL to generate a long list of one line scipts with a script like:

select 'drop table docsadm.'||lower(table_name)||';' from dba_tables
where owner = 'DOCSADM'
order by table_name asc;

Lastly, I run the result set of one line scipts.

Rock Cogar.
Radian International LLC.
Oak Ridge, TN. USA.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!