自己用的几个小脚本
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;
/
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;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20516214/viewspace-1361237/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
