I got ” ORA-56901 non-constant expression is not allowed for pivot|unpivot values ” error in Oracle database.
ORA-56901 non-constant expression is not allowed for pivot|unpivot values
Details of error are as follows.
ORA-56901 non-constant expression is not allowed for pivot|unpivot values Cause: Attempted to use non-constant expression for pivot|unpivot values. Action: Use constants for pivot|unpivot values.
non-constant expression is not allowed for pivot|unpivot values
This ORA-56901 error is related to Attempted to use non-constant expression for pivot|unpivot values.
Use constants for pivot|unpivot values.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )