procedure ems_user
create or replace procedure ems_user
as
cursor emp_cursor is
select u.login_name as logname,u.name as name from users u ;
begin
for emp_record in emp_cursor loop
dbms_output.put_line(emp_record.logname||emp_record.name);
end loop;
end;
-----执行
begin
-- Call the procedure
ems_user;
end;
www.2cto.com