PL/SQL 101 : WITH Clause

Version 3

    With my latest PL/SQL 101 instalment, I decided to tackle something that most experts will be very familiar with, yet we do a good job of confusing those people new to SQL by using it.... the beloved WITH clause.

     

    (22/02/2017 - edited to fix minor typo)

    (07/07/2017 - edited to remove a superfluous line of code that had snuck in)