Db/Oracle

Oracle function sample

seongsland 2010. 4. 6. 23:52
CREATE OR REPLACE FUNCTION FN_GET_DD (
    vi_seq IN VARCHAR2
)
    RETURN VARCHAR2 IS reStr VARCHAR2(50);

BEGIN
    reStr := '';

    SELECT DD INTO reStr
    FROM DDDD
    WHERE DD = vi_seq;

    RETURN reStr;
    EXCEPTION
      WHEN NO_DATA_FOUND THEN
        RETURN '';
      WHEN OTHERS THEN
        RETURN '';

END    FN_GET_DD;
/