Oracle Error ORA-32037: unsupported use of LEVEL in membership condition

Oracle Error Message

ORA-32037: unsupported use of LEVEL in membership condition

Reason for the Error

An attempt was made to use LEVEL in membership condition with subquery that is not supported.

Solution

Rewrite query to avoid using LEVEL in membership condition