create table natural_numbers(num1 number);
begin
for i in 1 .. 1000
loop
insert into natural_numbers values(i);
commit;
end loop;
end;
SELECT
TO_CHAR(ADD_MONTHS('01-JAN-2005',ROWNUM-1),'MON-YYYY')
FROM natural_numbers
WHERE ADD_MONTHS('01-JAN-2005',ROWNUM-1)
BETWEEN '01-JAN-2004' AND '01-DEC-2005';
create public synonym natural_numbers for
natural_numbers;
grant select on natural_numbers to allzone;