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

List value clause [Oracle SQL]

{ values ( literal-1 [ ... , literal-n ] [ , null ] ) } |
{ values ( default ) }
The list value clause appears within the list partition clause or the subpartition spec clause or the subpartition template.

Example

create table list_partitioned_tab ( 
  foo   number constraint list_partitioned_pk primary key,
  bar   date,
  word  varchar(10)
)
partition by list (word) (
  partition drinks       values ('Coke', 'Sprite', 'Fanta'),
  partition colors       values ('red' , 'green' , 'blue' ),
  partition numbers      values ('one' , 'two'            ),
  partition other_things values (default                  )
);