declare
v_l_studentid number := &studentid;
v_vc_firstname varchar2(20);
v_vc_lastname varchar2(20);
begin
--1.查询相关的信息
select a.first_name, a.last_name
into v_vc_firstname, v_vc_lastname
from student a
where a.student_id = v_l_studentid;
--2.打印学生姓名
dbms_output.put_line('stduent name is' || v_vc_firstname);
--3.处理异常
exception
when no_data_found then
dbms_output.put_line('there is no such a student!');
end;
PL/SQL学习代码实例1
最新推荐文章于 2021-04-08 17:42:42 发布