How to automatically generate a table with dates from 20000101 to 20500101 for a total of 50 years?

How to automatically generate a table with a date of 50 years from 20000101 to 20500101?

software environment: 1. Windows NT4.0 + Oracle 8.0.4 2. Oracle installation path: C: \ orant SQL statement: Drop table da_yyyymmdd; -- If yes, delete the table first. Create Table da_yyyymmdd (RQ char (8) primary key); -- create a table. RQ (date) is the primary keyword. declare I number; -- use cyclically J char (8); -- record the date value begin J: = '123 '; -- set the initial value for I in 1 .. 18250 loop -- 365*50 = 600 days insert into da_yyyymmdd values (j); -- insert record J: = to_char (to_date (J, 'yyyymmdd ') + 1, 'yyyymmdd'); -- date plus 1 day end loop; -- loop end end; / commit; -- submit, PL/SQL blocks are not automatically submitted