Oracle Error Message
ORA-56901: non-constant expression is not allowed for pivot|unpivot values
Reason for the Error
Attempted to use non-constant expression for pivot|unpivot values.
Solution
Use constants for pivot|unpivot values.
ORA-56901: non-constant expression is not allowed for pivot|unpivot values
Attempted to use non-constant expression for pivot|unpivot values.
Use constants for pivot|unpivot values.