Selecting Particular List of Table Partitions

For selecting rows of a table partition, we can use the following query :
SELECT * FROM TABLE_NAME PARTITION(ID_P_20070800A) But if i want to select a particular list of partitions from same table, how can i do that ?
Eg : I want to select partitions : ID_P_20070800A, ID_P_20080800A, ID_P_20090800A, from a particular table, how can i do that ?

Please help...

Thanks in Advance.

With Regards,
Raja. Received on Fri Nov 20 2009 - 03:30:40 CST