Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Selecting Particular List of Table Partitions

2 views
Skip to first unread message

raja

unread,
Nov 20, 2009, 4:30:40 AM11/20/09
to
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.

ddf

unread,
Nov 20, 2009, 8:39:11 AM11/20/09
to

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


David Fitzjarrell

Michel Cadot

unread,
Nov 20, 2009, 11:19:47 AM11/20/09
to

"raja" <dexte...@gmail.com> a �crit dans le message de news: 2053a119-f51a-4830...@g22g2000prf.googlegroups.com...

UNION ALL

Regards
Michel


raja

unread,
Nov 25, 2009, 2:20:17 AM11/25/09
to
On Nov 20, 9:19 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "raja" <dextersu...@gmail.com> a écrit dans le message de news: 2053a119-f51a-4830-9d4f-1b7183aef...@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.

0 new messages