语法能不能用软件匹配的大写的代码呢
用enter输入提示的代码，能不能运行
慕数据3013573
2018-07-09
1 回答
set serveroutput on
declare
cursor c is select name from tb_1 where id=5;
pname tb_1.name%type;
not_found_emp exception;
begin
open c;
fetch c into pname;
if c%notfound then
raise not_found_emp;
end if;
close c;
exception
when not_found_emp then DBMS_OUTPUT.PUT_LINE('没有找到5号员工');
when others then dbms_output.put_line('其他例外');
close c;
end;
/
举报
0/150
提交
取消
