Oracle 12c / Top N rows, pagination
In older versions, limiting sorted data by the number of rows had to be implemented using a nested query. This first sorted the table, and only then was it possible to filter by count.
Oracle 12c / User-defined function in the WITH clause
The option to define a PL/SQL function or procedure inside an SQL query might seem strange at first glance, but it has one significant advantage – the database does not need to switch context, which in certain cases leads to a massive increase in performance.
Oracle 12c / Querying from an associative array
To use an array in SQL queries, it was previously necessary to create a “stored” type on the SQL server side and assign the appropriate rights… Read more