Result cache can parameterize its result. Cached results are parameterized in the result cache if they include
- Bind variables
- SQL functions
- SYS_CONTEXT (with constant variables)
- USERENV (with constant variables)
- NLS parameters
These cached result set i.e. parameterized results can only be reused only if
- The very same query is executed.
- The same parameter values should be passed.
Result Cache With Bind Examples:
These cached result set i.e. parameterized results are reused only by executing the same query with the same bind value.