[ORACLE] DB Function 선언

CREATE OR REPLACE FUNCTION MyFunc (nInput NUMBER) 
    RETURN VARCHAR2 
IS 
    Ret VARCHAR2(14); 
BEGIN 
    SELECT dname 
      INTO Ret 
      FROM dept 
     WHERE deptno = nInput; 

    RETURN Ret; 
END;

참 쉽죠?

사용법은 ..?

nInput이 14라면

SELECT MyFunc(14) FROM DUAL;