first_rows(10)

first_rows(10)

 

  

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?

Oracle LazyDBA home page