문자열 수식을 입력받아 계산된 값 리턴.

CREATE OR REPLACE FUNCTION fnCalcStr
(
       str             VARCHAR2
)
RETURN NUMBER
IS RESULT_DATA NUMBER;
BEGIN
   
  
    EXECUTE IMMEDIATE 'SELECT ' || str || ' FROM DUAL' INTO RESULT_DATA;
    RETURN RESULT_DATA;

END;
/