Not a member of Pastebin yet?
                        Sign Up,
                        it unlocks many cool features!                    
                - DECLARE
 - TYPE t_nums IS TABLE OF NUMBER(38);
 - v_actual_nums t_nums := t_nums(0, 12, 1, 3, 0);
 - v_expected_nums t_nums := t_nums(12, 1, 3, 0, 0);
 - FUNCTION move_zeroes(p_nums t_nums) RETURN t_nums IS
 - BEGIN
 - -- YOUR CODE HERE
 - END;
 - PROCEDURE test(p_expected_nums t_nums
 - ,p_actual_nums t_nums) IS
 - BEGIN
 - IF (p_expected_nums IS NULL OR p_actual_nums IS NULL OR p_expected_nums.COUNT != p_actual_nums.COUNT) THEN
 - raise_application_error(-20100, 'Arrays are not equals');
 - END IF;
 - FOR i IN p_expected_nums.FIRST .. p_expected_nums.LAST LOOP
 - IF (p_expected_nums(i) != p_actual_nums(i)) THEN
 - raise_application_error(-20100, 'Arrays are not equals');
 - END IF;
 - END LOOP;
 - END;
 - BEGIN
 - v_actual_nums := move_zeroes(v_actual_nums);
 - test(v_expected_nums, v_actual_nums);
 - END;
 - /
 
Advertisement
 
                    Add Comment                
                
                        Please, Sign In to add comment