Author Archives: Oren Nakdimon

Lateral Inline Views

Oren Nakdimon 2 Replies

Lateral Inline Views – an official feature of Oracle 12c (was hidden/unsupported/undocumented in 11g) – lets you refer within an inline view to tables that appear to its left in the FROM clause. Let’s take an example (a simplification of a real-life use case I handled recently). We have a SCHEDULES table, including for each […]

Continue reading

The FIRST and LAST Aggregate Functions

Oren Nakdimon 1 Reply

One of my favorite aggregate functions in Oracle is FIRST (and of course its counterpart, LAST; ok, so two of my favorite aggregate functions). The very common aggregate functions MIN and MAX allow you (conceptually) to sort a group of rows by some column and return the value of that column from the first or […]

Continue reading