How to fix the Oracle error PGU-42001: ALL not valid in VALUE(S) clause at level 88?

In this post, you’ll learn more about the Oracle ErrorPGU-42001: ALL not valid in VALUE(S) clause at level 88 with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGU-42001: ALL not valid in VALUE(S) clause at level 88

Reason for the Error PGU-42001: ALL not valid in VALUE(S) clause at level 88

Cause: ALL cannot be specified in a level 88 (condition-names) entry

How to fix the Error PGU-42001: ALL not valid in VALUE(S) clause at level 88 ?

You can fix this error in Oracle by following the below steps

Action: Delete the reserved word ALL