create or replace procedure get_username as begin v_id in number:=1 select * from uc_t_staff t where t.id = v_id end get_username;