17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION getCustText (custName VARCHAR2)
RETURN VARCHAR2
IS
Result VARCHAR2 (100); --返回的结果字符串
tmp_custName VARCHAR2 (100); --临时变量
count_str NUMBER; --字符串中字符的个数
i NUMBER := 1; --循环变量
str_ascii NUMBER; --当前等待判断字符的ascii码
current_char VARCHAR2 (10); --当前等待判断的字符
BEGIN
SELECT LENGTH (custName) INTO count_str FROM DUAL; --取出待处理字符串的长度
WHILE i < count_str
LOOP ---根据待处理字符串长度(counts)?,逐个字符判断处理
current_char := SUBSTR (custName, i, 1);
SELECT ASCII (current_char) INTO str_ascii FROM DUAL;
IF str_ascii > 45216
THEN
tmp_custName := tmp_custName || current_char;
END IF;
i := i + 1;
END LOOP;
Result := tmp_custName;
RETURN (Result);
END getCustText;