12c FETCH PERCENT

(connormcdonald) A nice little feature in 12c is the FETCH FIRST n ROWS syntax, which is a simple shorthand to avoid using inline views and the like to get a subset of the rows from what would normally be a larger resultset.

Read More - Register for Free Membership