SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

First_rows(10) hint

616895Apr 17 2008 — edited Apr 17 2008

Hi All,

I try to set hint /*+ FIRST_ROWS(10) */ for only first 10 records from
result sets, but oracle bring me always all records; does I need to set
something on session or database for use of this hint?

Thanks,
Padma

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2008

Added on Apr 17 2008

4 comments

2,189 views