oracle数据库基本语句

set ServerOutput on;
declare
varname varchar2(50);
varid number;
cursor mycur(vartype number) is
select userid, username from userman.users
where usertype=vartype;
begin
if mycur%isopen=false then
open  mycur(1);
end if ;
fetch mycur into varid,varname;
while mycur%found
loop
dbms_output.put_line('用户编号：'||varid ||',用户名:'||varname);
fetch mycur into varid, varname;
end loop;
close mycur;
end;




//创建用户 userman 
create user userman
identified by userman
 

//创建角色myrole
create role myrole1 identified by myrolepwd;