Oracle Error ORA-02324: more than one column in the SELECT list of THE subquery

Oracle Error Message

ORA-02324: more than one column in the SELECT list of THE subquery

Reason for the Error

More than one column was selected in the THE subquery.

Solution

Specify only one column in the SELECT list of the THE subquery and retry the operation.