【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:22.5.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
--间隔分区
CREATE TABLE sales_interval
( PRODUCT_ID VARCHAR2(5),
time_id DATE NOT NULL,
SALES_COST NUMBER(10))
PARTITION BY RANGE (time_id)
INTERVAL(NUMTOYMINTERVAL(1, 'month'))
(PARTITION P0 values less than (TO_DATE('1-1-2002', 'dd-mm-yyyy')),
PARTITION P1 values less than (TO_DATE('1-1-2003', 'dd-mm-yyyy')),
PARTITION P2 values less than (TO_DATE('1-7-2003', 'dd-mm-yyyy')),
PARTITION P3 values less than (TO_DATE('1-1-2004', 'dd-mm-yyyy')))
CREATE TABLE customers_demo (
customer_id number(6),
cust_first_name varchar2(20),
cust_last_name varchar2(20),
credit_limit number(9,2))
PARTITION BY RANGE (credit_limit)
INTERVAL (1000)
(PARTITION p1 VALUES LESS THAN (5001));