Stable functions
When run with a given set of arguments, stable functions produce the same result within a single query or scan operation. However, a stable function can produce different results when issued under different environments or at different times, such as change of locale and time zone—for example, SYSDATE()
and 'today'
.
See also Immutable (Invariant) Functions.