| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Range partitioning clause [Oracle SQL] | ||
partition by range (column-name-1 [ , column-name-n ... ] (
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 composite partitioning clause, but without
an individual-hash-partitions-clause or hash-partition-by-quantity-clause clause.
The range partitioning clause appears as part within the table partitioning clause.
|