declare
deluser varchar2(40);
i number;
begin
deluser:='TEST';
select COUNT(*) into i from all_users where username= deluser;
IF i>0 then
EXECUTE immediate 'DROP USER '||deluser||' CASCADE';
END IF;
end;
deluser varchar2(40);
i number;
begin
deluser:='TEST';
select COUNT(*) into i from all_users where username= deluser;
IF i>0 then
EXECUTE immediate 'DROP USER '||deluser||' CASCADE';
END IF;
end;