Tuesday, November 17, 2009

Oralce PL/SQL : Creating calendar table

create table calendar(c_date date);

insert into calendar
select to_date(to_char(19900101), 'yyyymmdd') + lvl d
from ( select level -1 lvl
from dual
connect by level <= 20000);

No comments:

Post a Comment