Paginating the results from a query in Oracle

MySql has some interesting additions to standard SQL to show paginated results : the LIMIT n OFFSET skip clause. The website http://troels.arvin.dk/db/rdbms/#select-limit-offset shows a way of doing this in Oracle.