create table even(even_num number(5))

create table odd(odd_num number(5))

DECLARE  
      i number(5):=1; 
BEGIN  
    while i<=25 loop 
        if mod(i,2)=0 then 
            insert into even values(i); 
        else 
            insert into odd values(i); 
        end if; 
    i:=i+1; 
    end loop; 
END;

select * from odd

select * from even