morphman
asked on
select from partition range?
Is it possible to select from a partition range?
ie.
something like
select * from table partition range (partition1,partition3);
ie.
something like
select * from table partition range (partition1,partition3);
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I guess the answer is no then..
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;