Re: Selecting Particular List of Table Partitions

From: raja <dextersunil_at_gmail.com>
Date: Tue, 24 Nov 2009 23:20:17 -0800 (PST)
Message-ID: <ce748225-377d-4289-a17a-c90947807d09_at_u18g2000pro.googlegroups.com>



On Nov 20, 9:19 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "raja" <dextersu..._at_gmail.com> a écrit dans le message de news: 2053a119-f51a-4830-9d4f-1b7183aef..._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

Hi Michel,

Oh, ya, superb...........
Thanks a lot.

With Regards,
Raja. Received on Wed Nov 25 2009 - 01:20:17 CST

Original text of this message