Iggy Fernandez posted a riddle to be solved without PLSQL
I tend to second Steven Feuerstein argument :
Some people can perform seeming miracles with straight SQL, but the statements can end up looking like pretzels created by someone who is experimenting with hallucinogens.
In my book I mentionned techniques that enhance the basis functionality of SQL. Actually, many of those techniques allow you to write “shorter” statements than before (by avoid redundant subqueries) and also to gain performance, occasionnaly.
However the downside is that you will end up writting some code that only you can read.
In my opinion a zero-plsql approach is wrong. If you have a problem similar to Iggy Fernandez, then no no no, do not even try to solve it with SQL unless you are really doing this for fun
In my humble opinion, plsql and sql and complementary. If you want to program, use plsql. If you need to retrieve data, use sql.
And thanks a lot to Iggy for the excellent challenge !!!