存储过程-查询并循环输出

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;

   
/**
   -----执行方式1
   begin
      ems_user;
   end;
   -----执行方式2
   begin
      Call the procedure
   end;
*/