ORACLE SELECT INTO防止没结果时报错: 加异常处理
BEGIN
SELECT name
into v_name
FROM t_student
WHERE id = '101'
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_name := '';
WHEN OTHERS THEN
v_name := '多于一条啦';
END;
BEGIN
SELECT name
into v_name
FROM t_student
WHERE id = '101'
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_name := '';
WHEN OTHERS THEN
v_name := '多于一条啦';
END;