Advertisement
kivilevd

MoveZeros Leetcode Task

Jun 27th, 2023
1,449
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.85 KB | None | 0 0
  1. DECLARE
  2.   TYPE t_nums IS TABLE OF NUMBER(38);
  3.   v_actual_nums   t_nums := t_nums(0, 12, 1, 3, 0);
  4.   v_expected_nums t_nums := t_nums(12, 1, 3, 0, 0);
  5.  
  6.   FUNCTION move_zeroes(p_nums t_nums) RETURN t_nums IS
  7.   BEGIN
  8.     -- YOUR CODE HERE
  9.   END;
  10.  
  11.   PROCEDURE test(p_expected_nums t_nums
  12.                 ,p_actual_nums   t_nums) IS
  13.   BEGIN
  14.     IF (p_expected_nums IS NULL OR p_actual_nums IS NULL OR p_expected_nums.COUNT != p_actual_nums.COUNT) THEN
  15.       raise_application_error(-20100, 'Arrays are not equals');
  16.     END IF;
  17.     FOR i IN p_expected_nums.FIRST .. p_expected_nums.LAST LOOP
  18.       IF (p_expected_nums(i) != p_actual_nums(i)) THEN
  19.         raise_application_error(-20100, 'Arrays are not equals');
  20.       END IF;
  21.     END LOOP;
  22.   END;
  23.  
  24. BEGIN
  25.   v_actual_nums := move_zeroes(v_actual_nums);
  26.   test(v_expected_nums, v_actual_nums);
  27. END;
  28. /
Tags: Task
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement