select from partition range?

Is it possible to select from a partition range?

ie.

something like

select * from table partition range (partition1,partition3);

LVL 6
morphmanAsked:
Who is Participating?
 
pratikroyConnect With a Mentor Commented:
Not that I know of.

But you can certainly create a view that has the data from the range of partitions that you are interested in and select from the view.

e.g.,

create or replace view emp3 as
select * from emp partition (p1)
union all
select * from emp partition (p2)
union all
select * from emp partition (p3);

Hope that would help
0
 
seazodiacConnect With a Mentor Commented:
well, if you have a LOCAL index (as opposed to global),

you can achieve the same goal
by specifying the where clause :

for example: partition1 has the partition key from 1-50.
partition3 from 100-150.

you can do sth like this:

select * from <table_name>
where partition_key between 1 and 50
UNION
select * from <table_name>
where partition_key between 100 and 150.
0
 
sujit_kumarCommented:
select p_no, empno from (
select 1 p_no, empno from emp partition (p1)
union all
select 2 p_no, empno  from emp partition (p2)
union all
select 3 p_no, empno  from emp partition (p3))
where p_no betwee 1 and 2;

0
 
morphmanAuthor Commented:
I guess the answer is no then..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.