Re: Selecting Particular List of Table Partitions

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 20 Nov 2009 17:19:47 +0100
Message-ID: <4b06c19d$0$720$426a34cc_at_news.free.fr>


"raja" <dextersunil_at_gmail.com> a écrit dans le message de news: 2053a119-f51a-4830-9d4f-1b7183aefcb9_at_g22g2000prf.googlegroups.com...
| Hi,
|
| 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.

UNION ALL Regards
Michel Received on Fri Nov 20 2009 - 10:19:47 CST

Original text of this message