Nested Sets in Oracle (6)

I continue to compare the nested set model with the Oracle hierarchical model from where I left off in Nested Sets in Oracle (5).

I now have a way to do:

Now let’s produce a query that can retrieve our category tree, along with a product count for each category:

Continue reading