Query a partitoned table for data spanning in multiple partition

I want to make use of partition object as well as restrict my partition range.

Say my sales table is partitioned on monthly basis.

Now I want to query on say Decemeber and January Partition, I wish to know how to write a query to retrieve data from multiple partition.

Select * from sales partition (P200412) -- Decemeber Select * from sales partition (P200401) -- January Please advice how to acheive this via a single query.

Thanks,
Rishi Received on Fri Jan 28 2005 - 14:52:02 CST