Plsql first records

From John Freier
Jump to: navigation, search

To fetch the first 10 records from a result.

 SELECT *
 FROM table_a
 FETCH FIRST 1 ROW ONLY;