SELECT * FROM ( SELECT rownum rnum, tmpt.* FROM ( SELECT hoge.a,hoge.b,piyo.a,piyo.b FROM hoge LEFT JOIN piyo ON hoge.a=piyo.b ORDER BY hoge.a ) tmpt ) WHERE rnum>10 AND rnum<=10+20 ORDER BY rnum; hogeとpiyoの両方で同じカラム名があるとき、…

oci_fetch_row($sth)はNULLの要素を返してくれないのでoci_fetch_array($sth,OCI_NUM|OCI_RETURN_NULLS)を使う http://manual.xwd.jp/function.oci-fetch-array.html