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