SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Putting the partition name in a SELECT

869638Aug 5 2011 — edited Aug 5 2011

Hello,

I am trying to do something like this.

SELECT u.id FROM users PARTITION (SELECT partition_name FROM dba_tab_partitions WHERE table_name='users') u WHERE u.active=1

The problem is that you can't have a select in there to fetch the partion name. Is there any way I can do this in a single SELECT?

Thanks in advance

This post has been answered by Karthick2003 on Aug 5 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2011

Added on Aug 5 2011

5 comments

6,295 views