Re: Selecting Particular List of Table Partitions

From: ddf <oratune_at_msn.com>
Date: Fri, 20 Nov 2009 05:39:11 -0800 (PST)
Message-ID: <a291fe04-82f8-4716-9fc9-6feac5251c9e_at_m13g2000vbf.googlegroups.com>

On Nov 20, 4:30 am, raja <dextersu..._at_gmail.com> wrote:
> 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.

The same way you'd include multiple tables in your FROM clause.

David Fitzjarrell Received on Fri Nov 20 2009 - 07:39:11 CST