Yes it’s SCBT day here in Perth! SCBT = Silly Click Bait Title This post is just a cautionary tale
Just a quick revisit on an old topic so I could link to this post in a Stack Overflow discussion.
We’ve (hopefully) all had it drummed into us enough times – you cannot assume the order of results from queries
Within a CONNECT BY statement, you can order siblings, that is, under a particular branch of the hierarchy, the child
Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure