oracle code store
This is my Oracle code store
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment