CREATE TABLE sales_range
(salesman_id NUMBER(5) ,
salesman_name VARCHAR2(30),
sales_amount NUMBER(10) ,
sales_date DATE
)PARTITION BY RANGE(sales_date)
(PARTITION p2006q1 VALUES LESS THAN(TO_DATE('2006-04-01','YYYY-MM-DD')),
PARTITION p2006q2 VALUES LESS THAN(TO_DATE('2006-07-01','YYYY-MM-DD')),
PARTITION p2006q3 VALUES LESS THAN(TO_DATE('2006-10-01','YYYY-MM-DD')),
PARTITION p2006q4 VALUES LESS THAN(TO_DATE('2007-01-01','YYYY-MM-DD'))); |