OK, we all love a clever piece of code to do something a little bit tricky, but has everyone lost sight of the benefits of simplicity?
My case study for the day, a thread on the Oracle forums in which various all_objects, user_objects, connect by, MODEL, xmltable, and pipelined function techniques are suggested for generating a list of days.
Well, my comments are in the thread. Just use a table … that’s why we have them. Keep … it … simple.