1.创建用户
declare
v_string varchar2(100);
begin
for i in 1..100 loop
v_string:='create user test'||i||' identified by test'||i;
execute immediate v_string;
end loop;
end;
/

2.删除用户
declare
v_string1 varchar2(100);
begin
for i in 1..100 loop
v_string1:='drop user test'||i||' cascade';
execute immediate v_string1;
end loop;
end;
/