SELECT ROUTINE_NAME, ROUTINE_DEFINITION
  FROM INFORMATION_SCHEMA.ROUTINES

 WHERE ROUTINE_TYPE = 'FUNCTION'         -- 프로시저 : 'PROCEDURE'
   AND ROUTINE_SCHEMA = LOWER('public')  -- 스키마
   AND ROUTINE_NAME LIKE LOWER('%YN%')   -- 함수명
;