List Partitioning Example
CREATE TABLE sales_list
(salesman_id NUMBER(5),
salesman_name VARCHAR2(30),
sales_state VARCHAR2(20),
sales_amount NUMBER(10),
sales_date DATE)
PARTITION BY LIST(city_id)
(
PARTITION part1 VALUES(5810000),
PARTITION part2 VALUES (5820000),
....
PARTITION sales_other VALUES(DEFAULT)
);
CREATE TABLE sales_list
(salesman_id NUMBER(5),
salesman_name VARCHAR2(30),
sales_state VARCHAR2(20),
sales_amount NUMBER(10),
sales_date DATE)
PARTITION BY LIST(city_id)
(
PARTITION part1 VALUES(5810000),
PARTITION part2 VALUES (5820000),
....
PARTITION sales_other VALUES(DEFAULT)
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货