Range partitions of Oracle table partitions

RANGE partitions of Oracle table partitions use the range partition syntax for values of one or more columns in the table: [SQL] PARTITION BY RANGE (column_name) (www.2cto.com PARTITION part1 value less than (range1), PARTITION part2 value less than (range2 ),... [PARTITION partN value less than (MAXVALUE)]); range PARTITION Example 1: [SQL] CREATE TABLE SALES2 (PRODUCT_ID VARCHAR2 (5), SALES_DATE DATE NOT NULL, SALES_COST NUMBER (10) partition by range (SALES_DATE) (PARTITION P1 values less than (DATE '2017-01-01 '), PARTITION P2 values less than (DATE '1970-01-01 '), PARTITION P3 values less than (MAXVALUE); range PARTITION Example 2: [SQL] CREATE TABLE Sales (www.2cto.com Product_ID varchar2 (5), Sales_Cost number (10) PARTITION BY RANGE (Sales_Cost) (PARTITION P1 VALUES LESS THAN (1000 ), PARTITION P2 values less than (2000), PARTITION P3 values less than (3000); author jason5186