PL/SQL raises an exception, in which TWO of the following cases:
When the datatypes of SELECT clause and INTO clause do not match
When a SELECT statement returns more than one row
When a SELECT statement returns no rows
When INTO statement is missing in the SELECT statement