Specify Partition name dynamically in Select Clause

[mmvraja]

Hi,

I need to Specify Partition name dynamically in the Select Clause.

For Example:

select 'x'
From emp Partition (to_char(sysdate,'yyyyMM'))


Is it possible in Oracle. If so, How to Proceed. Or else any work around for it.

Because My query is taking more time to give the result. I need to restrict to a single partition.

I require it in a normal SQL and not in PL/SQL. I use this query in Bussiness Objects Report (Free hand sql).

Plz reply ASAP.

Thanks In advance.
Raja