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

Composite partitioning clause [Oracle SQL]

partition by range (column-name-1 [ , column-name-n ... ] )
subpartition-by-list-clause | subpartition-by-hash-clause
(
      partition [ partition-name-1 ] range-value-clause table-partition-description
[..., partition [ partition-name-n ] range-value-clause table-partition-description ... ]
)
This clause is very similar to the range partitioning clause, but it features an additional individual-hash-partitions-clause or an hash-partition-by-quantity-clause clause.
The composite partitioning clause appears as part within the table partitioning clause.