-
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;
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|