Oracle Developer👨🏻‍💻

Given an array nums, write a function to move all 0's to the end of it while maintaining the relative order of the non-zero elements.

Example:
Input: [0,12,0,1,3]
Output: [12,1,3,0,0]

– Создается по умолчанию - global
create sequence my_seq;

– С инкрементом только в рамках сессии
create sequence my_seq session;

-- Обратиться в разных сессиях
select my_seq.nextval from dual;

alter sequence my_seq restart;

-- До 23c
select 1 from dual;

declare
  v_var number;
begin
  select 1 into v_var from dual;
  dbms_output.put_line(v_var);
end;
/

-- 23c
select 1;

declare
  v_var number;
begin
  select 1 into v_var;
  dbms_output.put_line(v_var);
end;
/