ORACLE SELECT INTO 注意事项 同时提供一种日期维表的建立方式

因为BI作业需要，我需要制作一个日期维表，可惜苦逼ORACLE SQL基础太差，实在没法独立写出来，于是把网上搜到的SQL语句改了一番，变成了自己的，代码如下：

<pre name="code" class="sql">SELECT rownum AS skid,       to_char(d, 'q') AS cal_quar,       to_char(d, 'mm') AS cal_month,       to_char(d, 'yyyy') AS cal_year,       CASE         WHEN to_char(d, 'mm') = 12 AND to_char(d, 'iw') = '01' THEN          '53'         ELSE          to_char(d, 'iw')       END AS cal_week,       d AS cal_date  FROM (SELECT (DATE '2013-01-01') + (LEVEL - 1) AS d          FROM dual        CONNECT BY LEVEL <= 730)

这里仅仅是一个查询结果，要求是把20130101到20141231期间的每天输出为 一个日期表，所以又上网查了如何把结果输出成一个表

主要是 

select into table1 from table2;

类似这样的语法

于是我在我的代码中进行这样的改动却老是报错，后来经过一番查询，select into table1 from table2 同时要引用table2 的表结构 如果我依然用select into t1 from dual;肯定是不对的，因为dual表结构是不可以被引用的，所以这里的解决方法是先创好一个表 然后插入查询结果：

create cal_date_dim(    cal_id number primary key,    cal_month char(10),    cal_year    char(10),    cal_week   char(10),    cal_date     char(10));

-- insert into cal_date_dim (cal_id, cal_quar, cal_month, cal_year, cal_week, cal_date)SELECT rownum AS skid,       to_char(d, 'q') AS cal_quar,       to_char(d, 'mm') AS cal_month,       to_char(d, 'yyyy') AS cal_year,       CASE         WHEN to_char(d, 'mm') = 12 AND to_char(d, 'iw') = '01' THEN          '53'         ELSE          to_char(d, 'iw')       END AS cal_week,       d AS cal_date  FROM (SELECT (DATE '2013-01-01') + (LEVEL - 1) AS d          FROM dual        CONNECT BY LEVEL <= 730);