FUNCTION 예제

FUNCTION EXAMPLE

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;