Oracle Error ORA-22818: subquery expressions not allowed here

Oracle Error Message

ORA-22818: subquery expressions not allowed here

Reason for the Error

An attempt was made to use a subquery expression where these are not supported.

Solution

Rewrite the statement without the subquery expression.