| Good | Bad |
|---|---|
| {code} CREATE OR REPLACE FUNCTION f1 ( p1 NUMBER ) RETURN NUMBER DETERMINISTIC IS BEGIN RETURN p1 * 2; END; / {code} | {code} CREATE OR REPLACE FUNCTION lookup ( l_input NUMBER ) RETURN VARCHAR2 DETERMINISTIC IS BEGIN select value into l_output from LookupTable where key = l_input; END; / {code} |