After seeing many with clauses in the scripts in my project, even I tried to getting used to it (without knowing the power of cte). I had a chance to work with an oracle architect. That time he made me realize the power of cte. He tunned a query which was running 250 seconds long to just 2 seconds. After going through the modifications I learned something. With that after some days I tunned a query which was running for more than an hour to 8 minutes. It's very very powerful tool if it is used properly.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.