개발 참고자료

CREATE OR REPLACE FUNCTION LEFT( 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, 1, an_len);
END IF;

EXCEPTION
WHEN OTHERS THEN
RETURN '';
END LEFT;