X hits on this document

112 views

0 shares

0 downloads

0 comments

8 / 38

8

juliandyke.com

© 2007 Julian Dyke

Result Cache Restrictions

SQL query result sets cannot include rows from

dictionary tables

temporary tables

sequence CURRVAL and NEXTVAL pseudocolumns

SQL functions

CURRENT_DATE

CURRENT_TIMESTAMP

LOCAL_TIMESTAMP

SYS_CONTEXT (with non-constant variables)

SYS_GUID

SYSDATE

SYSTIMESTAMP

USERENV (with non-constant variables)

Non-deterministic PL/SQL functions

Document info
Document views112
Page views112
Page last viewedSun Dec 11 00:34:31 UTC 2016
Pages38
Paragraphs703
Words2667

Comments