X hits on this document

99 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 views99
Page views99
Page last viewedWed Dec 07 19:58:58 UTC 2016
Pages38
Paragraphs703
Words2667

Comments