Disregard the(.............) for display reasons only
So If all of these are in a table called cat and they all have a ID. Also there is a table called cat_rel that will display the parent cat to child cat relationship.
So I would want this diagram above to look like this:
Only giving me the duplicates.
here is the query I have so far:
select level, give_me_name(child_Cat_id)
connect by parent_Cat_id=prior child_cat_id
start with parent_cat_id in (select cat_id from store_root_Cat where store_id=21)
group by level, give_me_name(child_Cat_id)
having count(*) > 1