Selecting Particular List of Table Partitions

From: raja <>
Date: Fri, 20 Nov 2009 01:30:40 -0800 (PST)
Message-ID: <>


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

Original text of this message