Specify Partition name dynamically in Select Clause
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