One of Oracle 12c's coolest features was the introduction of the SQL standard OFFSET .. FETCH clause, as we can now write things like: SELECT * FROM film ORDER BY film_id FETCH FIRST 1 ROW ONLY This is querying the Sakila database. Most other databases had this clause (or a non-standard version of it) for … Continue reading Oracle’s OFFSET .. FETCH Can be Slower than Classic ROWNUM Filtering
Tag: ANSI-SQL
jOOQ Newsletter August 2013
Subscribe to this newsletter here Overwhelming feedback from the jOOQ User Survey jOOQ has been the leading Java Open Source SQL building tool for the last three years. Feedback on social media such as Facebook, Twitter, reddit, Stack Overflow has been very positive. The recent user survey was well received by an increasingly growing jOOQ … Continue reading jOOQ Newsletter August 2013