記録

create or replace procedure stu_recis
type record_type is record(
name students.student_name%type,
major major_lookup.major_desc%type);
student_recrecord_type;
begin
select student_name,major_descinto student_rec
from students a,major_lookup b
where student_id='A101' and a.college_major=b.major;
dbms_output.put_line(student_rec.name);
dbms_output.put_line(student_rec.major);
end;