I need an urgent help to build some logic in Oracle DB.
I have a table called TREE and in that we have data based on hierarchies.
We have columns like DataID and ParentID and DataID column is unique one.
And the data for DataID and ParentID will be this is like parent and child relation ship.
I need to get the count of all DataID's and Sub-dataID's of ParentID.
I need to get the count of this without using Start With connect by option.
Is there a way to get this done...