create or replace procedure ddt is
V_CreateUser_stmt VARCHAR2(100);
V_User_Name VARCHAR(20);
V_Num NUMBER := 2;
begin WHILE V_Num < 3 LOOP
V_User_Name := 'US' || V_Num;
V_CreateUser_stmt := 'CREATE USER ' || V_User_Name || ' IDENTIFIED BY ' || V_User_Name
||' DEFAULT TABLESPACE users QUOTA 5M on users';
EXECUTE IMMEDIATE V_CreateUser_stmt ; V_Num := V_Num + 1;
END LOOP;
end;
V_CreateUser_stmt VARCHAR2(100);
V_User_Name VARCHAR(20);
V_Num NUMBER := 2;
begin WHILE V_Num < 3 LOOP
V_User_Name := 'US' || V_Num;
V_CreateUser_stmt := 'CREATE USER ' || V_User_Name || ' IDENTIFIED BY ' || V_User_Name
||' DEFAULT TABLESPACE users QUOTA 5M on users';
EXECUTE IMMEDIATE V_CreateUser_stmt ; V_Num := V_Num + 1;
END LOOP;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货