what is RANGE_N?

RANGE_N is similar to CASE_N can be used for partition creations

RANGE_N can only be applied to INTEGER or DATE fields

ex: create table employee(
empno integer,
empname varchar(40),
empsal decimal(10,2),
empjoindate DATE
)
UNIQUE PRIMARY INDEX(empno,empjoindate)
PARTITION BY RANGE_N (
empjoindate between '2005-01-01' and '2006-12-31' each interval '1' month,
empjoindate between '2007-01-01' and '2008-12-31' each interval '7' day
);