建一个日期维表（数据仓库）

http://topic.csdn.net/u/20101221/23/c36ca886-6b3b-4eb0-bca3-2a444ce43a94.html

 

 

如何能插入三列 年月日

类似格式如下
year month day
2000 2010-01 2010-01-01
2000 2010-01 2010-01-02
2000 2010-01 2010-01-03
...
....
2010 2010-01 2010-01-01
2010 2010-01 2010-01-02
2010 2010-01 2010-01-03

   

 

 

SELECT to_char(DAY, 'yyyy') YEAR, to_char(DAY, 'yyyy-mm') MONTH, DAY FROM (SELECT to_date('2000-01-01', 'yyyy-mm-dd') + LEVEL - 1 DAY FROM dual CONNECT BY LEVEL <= to_date('2010-12-31', 'yyyy-mm-dd') - to_date('2000-01-01', 'yyyy-mm-dd') + 1)