How to fix the Oracle error QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET?

In this post, you’ll learn more about the Oracle ErrorQSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET

Reason for the Error QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET

The capability in question is not supported when the expression is not in the PARTITION BY clause

How to fix the Error QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET ?

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

Change the query so that the expression is in the PARTITION BY