Oracle select into prevents failure to report an error, oracleselect

Oracle select into prevents failure to report an error, oracleselect

As follows:

Begin select name into v_name FROM t_student WHERE id = '000000' exception when NO_DATA_FOUND THEN v_name: = ''; END;

In this way, you do not need to select count (1) from t_student where id = '000000' in advance to determine whether it is null.

The above caught exception only processes errors without data. If there are more than one error, you can use OTHERS to capture it.

Begin select name into v_name FROM t_student WHERE id = '000000' exception when NO_DATA_FOUND THEN v_name: = ''; when others then v_name: = 'More Than One la'; END;