分区表技术点总结.pdf
5墨值下载
drop table range_part_tab purge;
1
2
3
create table range_part_tab(id number,deal_date date,area_code number,contents
varchar2(4000))
4
partition by range(deal_date)
5
(
6
partition p1 values less than(TO_DATE('2022-02-01','YYYY-MM-DD')),
7
partition p2 values less than(TO_DATE('2022-03-01','YYYY-MM-DD')),
8
partition p3 values less than(TO_DATE('2022-04-01','YYYY-MM-DD')),
9
partition p4 values less than(TO_DATE('2022-05-01','YYYY-MM-DD')),
10
partition p5 values less than(TO_DATE('2022-06-01','YYYY-MM-DD')),
11
partition p6 values less than(TO_DATE('2022-07-01','YYYY-MM-DD')),
12
partition p7 values less than(TO_DATE('2022-08-01','YYYY-MM-DD')),
13
partition p8 values less than(TO_DATE('2022-09-01','YYYY-MM-DD')),
14
partition p9 values less than(TO_DATE('2022-10-01','YYYY-MM-DD')),
15
partition p10 values less than(TO_DATE('2022-11-01','YYYY-MM-DD')),
16
partition p11 values less than(TO_DATE('2022-12-01','YYYY-MM-DD')),
17
partition p12 values less than(TO_DATE('2023-01-01','YYYY-MM-DD')),
18
partition p_max values less than(maxvalue)
19
);
20
21
1. partition by range
22
2.values less than
23
3.partition p_max values less than(maxvalue)
24
4.
25
1.
26
27
28
29
insert into range_part_tab
30
(id, deal_date, area_code, contents)
31
select rownum,
32
to_date(to_char(sysdate - 365, 'J') +
33
trunc(DBMS_RANDOM.VALUE(0, 365)),
34
'J'),
35
ceil(dbms_random.value(590, 599)),
36
rpad('*', 400, '*')
37
from dual
38
connect by rownum <= 100000;
39
commit;
40
drop table range_interval_part_tab purge;
1
2
3
create table range_interval_part_tab(id number,deal_date date,area_code
number,contents varchar2(4000))
4
partition by range(deal_date)
5
INTERVAL (NUMTOYMINTERVAL(1,'month'))
6
(
7
partition p1 values less than(TO_DATE('2022-02-01','YYYY-MM-DD')),
8
partition p2 values less than(TO_DATE('2022-03-01','YYYY-MM-DD'))
9
);
10
11
12
INTERVAL (NUMTOYMINTERVAL(1,'month'))
13
INTERVAL (NUMTOYMINTERVAL(1,'year'))
14
INTERVAL (NUMTODSINTERVAL(1,'day'))
15
INTERVAL (NUMTODSINTERVAL(7,'day'))
16
2.
of 21
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论