How to fix the Oracle error PGU-42017: VALUES can be used only at level 88?

In this post, you’ll learn more about the Oracle ErrorPGU-42017: VALUES can be used only at level 88 with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGU-42017: VALUES can be used only at level 88

Reason for the Error PGU-42017: VALUES can be used only at level 88

Cause: The VALUES keyword can only be specified in a data definition describing a condition and only at level 88.

How to fix the Error PGU-42017: VALUES can be used only at level 88 ?

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

Action: If the defintion describes a condition, make sure it is at level 88; if the definition does not describe a condition, then use VALUE IS rather than VALUES ARE.