CREATE TABLE PART_TABLE (THEPK NUMBER, THEDATA NUMBER)
PARTITION BY RANGE (THEDATA) INTERVAL (1)
(PARTITION P1 VALUES LESS THAN (1))
Table created.
INSERT INTO PART_TABLE VALUES (1,1)
1 row(s) inserted.
INSERT INTO PART_TABLE VALUES (2,2)
1 row(s) inserted.
INSERT INTO PART_TABLE VALUES (3,3)
1 row(s) inserted.
COMMIT
Statement processed.
select * from part_table partition for (2)
THEPK | THEDATA | 2 | 2 |
---|