17,382
社区成员




CREATE OR REPLACE FUNCTION f_reverse_str(p_num NUMBER) RETURN NUMBER AS
v_num VARCHAR2(20);
v_result VARCHAR2(20);
v_count NUMBER;
BEGIN
v_num := to_char(p_num);
v_count := length(v_num);
FOR i IN 0 .. v_count - 1
LOOP
v_result := v_result || substr(v_num, v_count - i, 1);
END LOOP;
RETURN to_number(v_result);
END;