Oracle Error : SQL-02112: SELECT..INTO returns too many rows

A SELECT...INTO statement returned more rows than can be stored in the host variable provided.

There are 3 possible solutions: