The power of recursive WITH in SQL

[@andreas-wismann]

Great presenation again! Knowing that this is a syntax example, I just find it not beneficial to mix information (LEVEL) with formatting (PADDING) at such an early stage, hence the length restriction (@05:20)

[@vikram4755]

Nailed it, amazing explanation As per me With is one of the Python thing in Oracle - with all due respect to Oracle The flexibility which With offers is awesome .. be it function, recursion, and many more

[@mohamedaminesekkai7326]

Thanks Connor. Great video.

[@DatabaseDude]

My pleasure!

[@georzbbz957]

Thanks a lot Connor.

[@DatabaseDude]

most welcome!

[@DoodyAtraktsi]

Brilinat series of videos for newbees as well 7.3.4 fans. Please keep it comming. Thanks!

[@DatabaseDude]

Thanks, will do!

[@yuri_p8984]

The simple SQL become more and more complex ...

[@DatabaseDude]

I must admit - I still find CONNECT BY more intuitive