【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了22.9.2.1.sql相关资料,希望对各位网友有所帮助!
--
列表-范围分区
CREATE TABLE customers_list_range (
customer_id NUMBER(6),
cust_first_name VARCHAR2(20),
cust_last_name VARCHAR2(20),
nls_territory VARCHAR2(30),
credit_limit NUMBER(9,2))
PARTITION BY LIST (nls_territory)
SUBPARTITION BY RANGE (credit_limit)
SUBPARTITION TEMPLATE
(SUBPARTITION p1 VALUES LESS THAN (1000),
SUBPARTITION p2 VALUES LESS THAN (2500),
SUBPARTITION p3 VALUES LESS THAN (MAXVALUE))
(PARTITION east VALUES
('CHINA', 'JAPAN', 'INDIA', 'THAILAND'),
PARTITION west VALUES
('AMERICA', 'GERMANY', 'ITALY', 'SWITZERLAND'),
PARTITION other VALUES (DEFAULT));