create or replace procedure stu_record
(v_student_Id in varchar2) is
recstudents%ROWTYPE;
begin
select student_Id ,student_name
into rec.student_Id,rec.student_name from students
where student_id=v_student_Id ;
dbms_output.put_line(rec.student_id);
dbms_output.put_line(rec.student_name);
end stu_record;
%ROWTYPE
最新推荐文章于 2024-09-11 11:00:10 发布