select t2.* from (select t1.*,rownum rnum from
(
select order_id,order_type from orderA
union all
select order_id,order_type from orderB
union all
select order_id,order_type from orderC
) t1 )t2 where t2.rnum>1 and t2.rnum<10
注:
t2.rnum>1 and t2.rnum<10 其中的1和10是穿过来的可变参数
如果有不懂的可以再问我……