What is the problem?
Well let me describe it this way: You know that your google pr is calculated using recommendation links for example you have one back link on
http://yoursite.com/index.php
and another on your site:
http://yoursite.com/
First link will give your index.php page pr and second will give pr to your domain (just root). Main problem is that you [...]

Alot of folks have problems when they first transfer to Oracle from MySQL.
Most of those problems are cosed by absence of LIMIT.
Just to give you all a hint in the right direction here is the simplest “pagination” query used on Oracle.
(select * from emp
where rownum