第3个回答 2011-12-16
pl/sql中:
CREATE OR REPLACE FUNCTION CHAR_NUMBER(P_CHAR VARCHAR2) RETURN VARCHAR2
IS
P_RETURN VARCHAR2(50);
P_MOD NUMBER;
BEGIN
SELECT MOD(P_CHAR,2)
INTO P_MOD
FROM DUAL;
IF P_MOD=1 OR P_MOD=0 THEN
P_RETURN :=P_CHAR||' IS NUMBER';
RETURN P_RETURN;
END IF ;
EXCEPTION
WHEN OTHERS THEN
P_RETURN :=P_CHAR||' IS CHAR';
RETURN P_RETURN;
END CHAR_NUMBER;
测试:
SELECT CHAR_NUMBER('TT3TT') AS P_TYPE
FROM DUAL;本回答被提问者采纳