Creativity vs Functionality – A Tale of a Query’s Development
Recently, I had a satisfying conclusion to a series of questions that came in randomly over the course of a few weeks. First the developer was trying to do recursion. I pointed to documentation and gave a couple of small examples showing CONNECT BY and recursive WITH clauses. SELECT LPAD(‘ ‘, LEVEL * 2) ||…