procedure ems_user

		
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.zzzyk.com  
 
						
		
	

上一个：Teradata分页排序
下一个：mongodb固定集合(Capped Collection)和大文件管理(GridFS)