title: CONNECT_BY_ISLEAF with Conditions
body: <p>I have a hierarchical set-up going on a table using the whole <code>START WITH</code> and <code>CONNECT BY</code> clauses, which I am using to set-up a vertical-aligned menu system that can expand out to the right, depending on if a menu option has children and the total number of Levels. Also, as part of the menu option, if a parent has children, I also display a <code>'&gt;'</code> symbol to specify this.</p>
  
  <p>My question is, I am using <code>CONNECT_BY_ISLEAF</code> to determine whether a menu option is a leaf or not but I also have a column in my hierarchical table that specifies whether the menu option is active or not. </p>
  
  <p>So when I have a case of a parent/child set-up in my menu, so that the <code>ISLEAF</code> value for <code>Parent</code> is <code>0</code> and <code>Child</code> is <code>1</code>, but I have actually made the Child menu option inactive, my <code>'&gt;'</code> symbol still displays at the parent level, even though the child record for this parent is inactive.</p>
  
  <p>Any idea how I can check this alongside with the <code>CONNECT_BY_ISLEAF</code> value, to prevent the <code>'&gt;'</code> symbol appearing even though this parent menu option has an inactive child record?</p>
  
  <p>Basically want something that, if a child record exists based on <code>ISLEAF</code> value but child record is inactive, then ignore this leaf record and pretend it doesn't actually exist.</p>