Re: Reg. 'drop table' statement

From: Harald Maier <maierh_at_myself.com>
Date: Mon, 18 Aug 2003 14:39:52 +0200
Message-ID: <m3zni716nb.fsf@ate.maierh>

qazmlp1209_at_rediffmail.com (qazmlp) writes:

> I want to drop the table where table names ends with 'TESTTABLE'.
> I tried with this:
> drop table (select tname where tname like '%TESTTABLE');
>
> But, it does not work.

Try this, but be careful and please do not crosspost. Harald

spool abc.sql

set heading off
set feedback off
select 'drop table ' || tname || ';' from tab where tname like '%TESTTABLE';

spool off
set heading on
set feedback on
@abc.sql Received on Mon Aug 18 2003 - 07:39:52 CDT