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;
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;