Hi all,

Can someone tell me what's wrong with the following, and how do I correct it, it's not working. Or is there a simple way to do this?
Thanks.

declare
num integer;
begin
select 1 into num where exists(select 1 from user_objects where object_name='T');
if (num=1) then
execute immeidate 'drop table t cascade';
end if;
end;
/