Oracle Error ORA-54002: only pure functions can be specified in a virtual column expression

Oracle Error Message

ORA-54002: only pure functions can be specified in a virtual column expression

Reason for the Error

Column expression contained a function whose evaluation is non-deterministic.

Solution

Rewrite column expression to reference only pure functions.