//t1 为主表，t2为子表

//分页原则 先将主表分页，再查子表内容

SELECT t1.*,t2.*

FROM TABLENAME1 t1,TABLENAME2 t2 WHERE t1.ID = t2.PID
AND t2.PID IN(SELECT ID FROM(SELECT ID,rownum FROM TABLENAME1 WHERE rownum <=pageNum*pageSize) WHERE rownum > (pageNum-1)*pageSize)

ORDER BY t1.VC_DATE DESC

原文链接：https://www.f2er.com/oracle/213421.html