Oracle table partition: range Partition

Partitions by the range of values of one or more columns in a table.

Syntax:

1. PARTITIONBYRANGE (column_name)
2. (
3. PARTITION part1 value less than (range1 ),
4. PARTITION part2 value less than (range2 ),
5. ...
6. [PARTITION partN value less than (MAXVALUE)]
7. );

Range partition Example 1:

1.  CREATE TABLESALES2 (
2. PRODUCT_ID VARCHAR2 (5 ),
3. SALES_DATEDATE NOT NULL,
4. SALES_COST NUMBER (10 ))
5. PARTITIONBYRANGE (SALES_DATE)
6. (
7. PARTITION P1VALUESLess (DATE'2017-01-01 '),
8. PARTITION P2VALUESLess (DATE'2017-01-01 '),
9. PARTITION P3VALUESLess than (MAXVALUE)
10. );

Range partition Example 2:

1. CREATE TABLESales
2. (
3. Product_ID varchar2 (5 ),
4. Sales_Cost number (10)
5. )
6. PARTITIONBYRANGE (Sales_Cost)
7. (
8. PARTITION P1VALUESLess than (1000 ),
9. PARTITION P2VALUESLess than (2000 ),
10. PARTITION P3VALUESLess than (3000)
11. );

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12