Read the function logic to zero

Read the function logic to zero

Drop table t; Create Table T as select * From dba_objects; create or replace function f_no_result_cache return number asv_return number; beginselect count (*) into v_return from t; return v_return; end; /set autotrace on effecf_no_result_cache from dual; -- check the result of calling f_no_result_cache for 2nd times. Select f_no_result_cache from dual; create or replace function f_result_cache return number result_cache as v_return number; begin select count (*) into v_return from t; return v_return; end;/select f_result_cache from dual; -- select f_result_cache from dual based on the result of calling f_result_cache for 2nd times;