René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Range value clause [Oracle SQL]

values less than ( literal-1 [ ... , literal-n ] )
or 
values less than ( maxvalue)
The range value clause appears as part within the composite partitioning clause or the range partitioning clause.

Example

create table items (
  item_id     number constraint items_pk primary key,
  description varchar2(30) not null,
  price       number       not null
)
partition by range (price) (
  partition price_lt_100   values less than (     100),
  partition price_lt_1000  values less than (    1000),
  partition price_lt_10000 values less than (   10000),
  partition price_rest     values less than (maxvalue)
);