InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 05:45:39 GMT20http://www.sqlservercentral.com/Forums/Topic1419084-1044-1.aspx[quote][b]anilkumar04_b (2/12/2013)[/b][hr]Hi All,I need to get the count of this without using Start With connect by option.[/quote]Why? Whats wrong with the CONNECT BY option?Fri, 15 Feb 2013 16:05:04 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1419084-1044-1.aspx[url=http://www.dba-oracle.com/t_recursive_subquery_factoring_with_clause.htm]if the oracle is 11.2 or later you can use recursive WITH-sql instead of connect by[/url]Fri, 15 Feb 2013 14:05:18 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1419084-1044-1.aspxHi All,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...ThanksAnilkumar BTue, 12 Feb 2013 10:18:46 GMTanilkumar04_b