Oracle Error PLS-01419: Subquery must have either ‘*’ or exactly one column in its select list

Oracle Error Message

PLS-01419: Subquery must have either ‘*’ or exactly one column in its select list

Reason for the Error

Subquery must have either ‘*’ or exactly one column in its select list according to ANSI’s grammar.

Solution

None