第一个ORACLE函数

create or replace function LowerNumToUpperChars(value int) return varchar2 is
  Result varchar2(10);
begin

    Result := 
    CASE value WHEN 0 THEN '零'
    WHEN 1 THEN '一'
    WHEN 2 THEN '二'
    WHEN 3 THEN '三'
    WHEN 4 THEN '四'
    WHEN 5 THEN '五'
    WHEN 6 THEN '六'
        WHEN 7 THEN '七'
        WHEN 8 THEN '八'
        WHEN 9 THEN '九'
        ELSE ''
        END ;
 
  return(Result);
end LowerNumToUpperChars;

-----------------------
DECLARE v_result VARCHAR2(10);
BEGIN
v_result := lowernumtoupperchars(7);
dbms_output.put_line('值'|| v_result);
END;

 

转载于:https://www.cnblogs.com/cgdou/p/3704704.html