Oracle创建时间维度
来源:互联网 发布:东风(十堰)整合优化 编辑:程序博客网 时间:2024/04/20 03:03
SQL Scripts to create Date Dimension in Oracle.
Create Table SQL:
CREATE TABLE Date_D(
DateKey Integer NOT NULL,
DateValue Date NOT NULL,
Day Char(10 ),
DayOfWeek Integer,
DayOfMonth Integer,
DayOfYear Integer,
PreviousDay date,
NextDay date,
WeekOfYear Integer,
Month Char(10 ),
MonthOfYear Integer,
QuarterOfYear Integer,
Year Integer
)
SQL To populate the table:
INSERT INTO Date_D
SELECT
to_number(to_char(CurrDate, 'YYYYMMDD')) as DateKey,
CurrDate AS DateValue,
TO_CHAR(CurrDate,'Day') as Day,
to_number(TO_CHAR(CurrDate,'D')) AS DayOfWeek,
to_number(TO_CHAR(CurrDate,'DD')) AS DayOfMonth,
to_number(TO_CHAR(CurrDate,'DDD')) AS DayOfYear,
CurrDate - 1 as PreviousDay,
CurrDate + 1 as NextDay,
to_number(TO_CHAR(CurrDate+1,'IW')) AS WeekOfYear,
TO_CHAR(CurrDate,'Month') AS Month,
to_number(TO_CHAR(CurrDate,'MM')) AS MonthofYear,
to_number((TO_CHAR(CurrDate,'Q'))) AS QuarterOfYear,
to_number(TO_CHAR(CurrDate,'YYYY')) AS Year
FROM (
select level n, TO_DATE('31/12/2009','DD/MM/YYYY') + NUMTODSINTERVAL(level,'day') CurrDate
from dual
connect by level <= 1000)
order by 1
- Oracle创建时间维度
- 创建时间维度数据
- 时间维度创建
- 创建时间维度数据
- Oracle中创建时间维度表并插入数据
- mysql中创建时间维度
- MS SQL Server 创建时间维度
- mysql创建时间维度的sql脚本
- 建时间维度表(oracle)
- 数据仓库开发之路--时间维度的创建
- 数据仓库时间维度
- Cube中时间维度
- 数据仓库的时间维度
- HBase中的时间维度
- 关注时间维度
- HBase中的时间维度
- HBase中的时间维度
- mysql时间维度表。
- 快速排序
- Oracle事务与函数
- MS SQL Server 创建时间维度
- 统计一个单位职工的年龄,要求把相同年龄最多的那个年龄找出来(可能有几个这样的年龄),并统计出现的次数
- Practical_C_Programming_chapter_7
- Oracle创建时间维度
- 黑马程序员 (7k面试) 交通灯程序设计学习总结
- java常用转义字符
- 最短路径问题
- 复制构造函数
- seo优化
- sql基础操作
- 比你优秀的人比你更努力
- 学习google最新下拉刷新控件SwipeRefreshLayout