-
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
Last edited by mmvraja; 12-15-2004 at 01:13 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|