Oracle Function 예제

Oracle Function 예제

CREATE OR REPLACE FUNCTION TRF.fnCalcStr

(

       str             VARCHAR2

)

RETURN VARCHAR2

IS RESULT_DATA VARCHAR2(100);

BEGIN 

    

   

    EXECUTE IMMEDIATE 'SELECT ' || str || ' FROM DUAL' INTO RESULT_DATA;

    RETURN RESULT_DATA;

END;

/

호출 : SELECT CalcFunction, fnCalcStr(CalcFunction) FROM TESTTABLE;