编写Oracle简单的存储过程

create or replace procedure SELECT_Users
is

 user_id number;
 logon_name varchar2(50);
 user_name varchar2(50);
begin
 select userid,logonname,username into user_id,logon_name, user_name from users;
end SELECT_Users;

转载于:https://www.cnblogs.com/lingxzg/archive/2008/07/07/1237348.html