개발 참고자료

CREATE OR REPLACE FUNCTION RIGHT( as_source IN CHAR,
an_len IN NUMBER ) RETURN VARCHAR
AS
BEGIN
IF trim(as_source) IS NULL THEN
RETURN '';
ELSE
RETURN substr(as_source, length(as_source) - (an_len - 1) );
END IF;

EXCEPTION
WHEN OTHERS THEN
RETURN '';
END RIGHT;