Stable functions

See also Immutable (invariant) 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.

See also Immutable (invariant) functions.