영역 분할은 PARTITION BY RANGE 문을 이용하여 정의한다.
CREATE
TABLE(
...
)
PARTITION BY RANGE ( <partition_expression> ) (
PARTITION <partition_name> VALUES LESS
THAN ( <range_value> ),
PARTITION <partition_name> VALUES LESS
THAN ( <range_value> ) ),
... )
)
CREATE TABLE participant2 (host_year INT, nation
CHAR(3), gold INT, silver INT, bronze INT)
PARTITION BY RANGE (host_year)
(PARTITION before_2000 VALUES LESS THAN (2000),
PARTITION before_2008 VALUES LESS THAN (2008) );
INSERT INTO participant2 VALUES (1988, 'NZL', 3, 2, 8);
INSERT INTO participant2 VALUES (1988, 'CAN', 3, 2, 5);
INSERT INTO participant2 VALUES (1996, 'KOR', 7, 15, 5);
INSERT INTO participant2 VALUES (2000, 'RUS', 32, 28, 28);
INSERT INTO participant2 VALUES (2004, 'JPN', 16, 9, 12);
INSERT INTO participant2 VALUES(NULL, 'AAA', 0, 0, 0);