hepi的专栏

FUNCTION convert_money(input_number NUMBER) RETURN VARCHAR2 IS i PLS_INTEGER; snum VARCHAR2(20) := ltrim(REPLACE(to_char(abs(input_number), '9999999999999990.99'), '.')); len PLS_INTEGER

FUNCTION convert_quantity(p_digit IN NUMBER) RETURN VARCHAR2 IS l_left_str VARCHAR2(100); ---左边字符串 l_right_str VARCHAR2(100); ---右边字符串 l_unit_str VARCHAR2(100); ---位 l_number_str