X hits on this document

139 views

0 shares

0 downloads

0 comments

14 / 38

14

juliandyke.com

© 2007 Julian Dyke

PL/SQL Function Result Cache Example Function

The function declaration must include the RESULT_CACHE clause

The RELIES_ON clause is optional, but recommended

CREATE OR REPLACE FUNCTION get_team_name (p_team_key NUMBER) RETURN VARCHAR2 RESULT_CACHE RELIES_ON (team) IS l_team_name VARCHAR2(50); BEGIN SELECT team_name INTO l_team_name FROM team WHERE team_key = p_team_key; RETURN l_team_name; END; /

SELECT get_team_name ('FER') FROM dual;

Document info
Document views139
Page views141
Page last viewedFri Jan 20 03:02:03 UTC 2017
Pages38
Paragraphs703
Words2667

Comments