摘要: 获取首字母大写 CREATE OR REPLACE FUNCTION F_PINYIN(P_NAME IN VARCHAR2) RETURN VARCHAR2 AS V_COMPARE VARCHAR2(100); V_RETURN VARCHAR2(4000); FUNCTION F_NLSSOR 阅读全文
posted @ 2022-05-18 17:42 qiaoyizhi 阅读(16) 评论(0) 推荐(0) 编辑
摘要: CREATE OR REPLACE FUNCTION FN_GETPY(p_str IN VARCHAR2, p_flag NUMBER DEFAULT NULL) RETURN VARCHAR2 AS v_compare VARCHAR2(4); v_return VARCHAR2(4000); 阅读全文
posted @ 2022-05-18 16:54 qiaoyizhi 阅读(34) 评论(0) 推荐(0) 编辑