Hello:
Another problem with refactoring is with -variable: Example:
CREATE OR REPLACE FUNCTION f_test RETURN NUMBER IS
v_number NUMBER := 2;
BEGIN
v_number := -v_number;
RETURN(v_number);
END;
If variable v_number is refactored to v_number2, this is the result:
CREATE OR REPLACE FUNCTION f_test RETURN NUMBER IS
v_number2 NUMBER := 2;
BEGIN
v_number2 := -v_number;
RETURN(v_number2);
END;
Thanks