Database Error Messages

Non-aggregate expressions were used in the PIVOT clause of the SELECT statement, which is not allowed.

Only aggregate functions are allowed in the PIVOT clause. Rewrite the SELECT statement and remove all non-aggregate functions and resubmit. Refer to Oracle Database documentation for the syntax of the PIVOT clause.

Attempted to use non-aggregate expression inside pivot operation.

Use aggregate function.

Attempted to use non-aggregate expression inside pivot operation.

Use aggregate function.