ORACLE SELECT into prevents no results times wrong

As follows:

  BEGIN    SELECT name into      v_name from      t_student     WHERE id = ' 101 '  EXCEPTION when    no_data_found Then      v_name: = ";  END;

In this way, you do not have to select COUNT (1) from t_student where id = ' 101 ' in advance to determine if it is empty.

The above catch exception will only handle errors with no data, and if more than one error can be captured with others

  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: = ' more than a bar ';  END;

ORACLE SELECT into prevents no results times wrong